Table keywords
- CLUSTERING ORDER BY ( column_name ASC | DESC)
-
Order rows storage to make use of the on-disk sorting of columns. Specifying order can make query results more efficient. Options are:
ASC: ascending (default order)DESC: descending, reverse order
- COMPACT STORAGE (5.1 only)
-
Use
WITH COMPACT STORAGEto store data in the legacy (Thrift) storage engine format to conserve disk space.
|
The current storage engine is much more efficient at storing data, and compact storage is not necessary. |
- ID
-
If a table is accidentally dropped with DROP TABLE, use this option to recreate the table and run a commit log replay to retrieve the data.
