Back to Questdb

ALTER TABLE COLUMN CACHE | NOCACHE

documentation/query/sql/alter-table-alter-column-cache.md

latest528 B
Original Source

ALTER TABLE ALTER COLUMN CACHE | NOCACHE changes the cache setting for a symbol column.

Syntax

  • columnName is the symbol data type.
  • By default, a symbol column is cached.
  • Refer to the Guide on symbol for the advantages of caching symbols.

Examples

questdb-sql
ALTER TABLE 'taxi_ride' ALTER COLUMN passenger_count NOCACHE;