QuestDB
EnterpriseCustomersDocsBlog
8.3.1
  • Roadmap
Download
  • Introduction
  • Quick start
  • Why QuestDB?
  • Schema Design Essentials
  • Migrate from InfluxDB
  • Ingestion Reference
  • Query & SQL Reference
    • Query & SQL Overview
    • Data types
    • SQL execution order
    • SQL Syntax
      • ADD USER
      • ALTER
        • ALTER COLUMN
        • ALTER SERVICE ACCOUNT
        • ALTER TABLE
          • ADD COLUMN
          • ATTACH PARTITION
          • COLUMN TYPE
          • SYMBOL CAPACITY
          • DETACH PARTITION
          • DEDUP DISABLE
          • DROP COLUMN
          • DROP PARTITION
          • DEDUP ENABLE
          • RENAME COLUMN
          • RESUME WAL
          • SET PARAM
          • SET TYPE
          • SET TTL
          • SQUASH PARTITIONS
        • ALTER MATERIALIZED VIEW
        • ALTER USER
      • ASSUME SERVICE ACCOUNT
      • CANCEL QUERY
      • CHECKPOINT
      • COPY
      • CREATE
      • DROP
      • EXPLAIN
      • EXIT SERVICE ACCOUNT
      • GRANT
      • INSERT
      • REFRESH MATERIALIZED VIEW
      • REINDEX
      • RENAME TABLE
      • REMOVE USER
      • REVOKE
      • SELECT
      • SHOW
      • SNAPSHOT
      • TRUNCATE TABLE
      • UNION EXCEPT INTERSECT
      • UPDATE
      • VACUUM TABLE
    • Functions
    • Operators
  • Deployment
  • Operations
  • Guides & Tutorials
  • Concepts
  • Third-party Tools
  • Troubleshooting
  • Query & SQL Reference
  • SQL Syntax
  • ALTER
  • ALTER TABLE
  • DEDUP DISABLE

ALTER TABLE DEDUP DISABLE

Disable storage level data deduplication on inserts

Syntax​

Flow chart showing the syntax of the ALTER TABLE DISABLE DEDUP statement

Example​

Disable deduplication on table TICKER_PRICE:

ALTER TABLE TICKER_PRICE DEDUP DISABLE

See more example at data deduplication page

Edit this page
Previous
DETACH PARTITION
Next
DROP COLUMN
  • Syntax
  • Example

Need a hand? Join our vibrant public Slack and Discourse forum communities.

Copyright © 2025 QuestDB
PrivacyTerms