QuestDB
Product
Learn
PricingDocs
7.4.0
Login
Get QuestDB
An icon showing a hamburger menu
QuestDB

ALTER TABLE COLUMN CACHE | NOCACHE

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

Syntax​

Flow chart showing the syntax of the ALTER TABLE keyword Flow chart showing the syntax of NOCACHE | CACHE

  • 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​

ALTER TABLE 'taxi_ride' ALTER COLUMN passenger_count NOCACHE;