QuestDB LogoQuestDB Logo
Return to QuestDB.comDocumentationTutorialsBlogEnterprisePublic SlackDiscourse CommunityView QuestDB Repo
⚡️ QuestDB Enterprise
9.2.3|16.5k
  • Release Notes
  • Roadmap
  • Getting Started
    • Introduction
    • Quick startPopular
    • Why QuestDB?Popular
    • Schema Design EssentialsPopular
    • Capacity planning
    • Create a sample database
    • Upgrade to EnterpriseEnterprise
    • Enterprise Quick StartEnterprise
    • Web Console
  • Connect & Ingest
  • Query Data
  • Concepts
  • Architecture
  • Configuration
  • SecurityEnterprise
  • High AvailabilityEnterprise
  • Operations
  • Deployment
  • Integrations
  • Tutorials
  • Troubleshooting
  • SQL Reference
    • ADD USEREnterprise
    • ALTER
      • ALTER COLUMN (TABLE)
      • ALTER COLUMN (VIEW)
      • ALTER SERVICE ACCOUNTEnterprise
      • ALTER TABLE
        • ADD COLUMN
        • ATTACH PARTITION
        • COLUMN TYPE
        • DEDUP ENABLE
        • DEDUP DISABLE
        • DETACH PARTITION
        • DROP COLUMN
        • DROP PARTITION
        • RENAME COLUMN
        • RESUME WAL
        • SET PARAM
        • SET TTL
        • SET TYPE
        • SQUASH PARTITIONS
        • SYMBOL CAPACITY
      • ALTER MATERIALIZED VIEW
      • ALTER USEREnterprise
      • ALTER VIEW
    • ASSUME SERVICE ACCOUNTEnterprise
    • CANCEL QUERY
    • CHECKPOINT
    • COMPILE VIEW
    • COPY
    • CREATE
    • DROP
    • EXIT SERVICE ACCOUNTEnterprise
    • EXPLAIN
    • GRANTEnterprise
    • INSERT
    • REFRESH MATERIALIZED VIEW
    • REINDEX
    • REMOVE USEREnterprise
    • RENAME TABLE
    • REVOKEEnterprise
    • SELECT
    • SHOW
    • SNAPSHOT
    • TRUNCATE TABLE
    • UNION EXCEPT INTERSECT
    • UPDATE
    • VACUUM TABLE
  • Release Notes
  • SQL Reference
  • 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
DEDUP ENABLE
Next
DETACH PARTITION
  • Syntax
  • Example

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

Copyright © 2025 QuestDB
PrivacyTerms