Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Actual data in Treasure Data is stored as a columnar storage format, which is optimized for the query using only specific columns. Restricting accessed columns can improve your query performance significantly. Specify only needed columns instead of using a wildcard (*).

Code Block
linenumberstrue
[GOOD]: SELECT time,user,host FROM tbl
[BAD]:  SELECT * FROM tbl

...