_______ is a database design technique that involves breaking down large tables into smaller, more manageable parts to improve performance.
- Denormalization
- Indexing
- Normalization
- Sharding
Sharding is a database design technique where large tables are broken down into smaller, more manageable parts called shards. Each shard is an independent database table, which can enhance performance by distributing the data across multiple servers or nodes. This technique is often used in distributed databases.
Loading...
Related Quiz
- What distinguishes ER diagram tools at the intermediate level from basic diagramming software?
- _______ databases are optimized for write-heavy workloads and are often used for real-time analytics.
- Forward Engineering typically involves the creation of _______ scripts to generate a database schema from a conceptual model.
- The _______ statement in SQL is used to retrieve data from a database.
- In an Entity-Relationship Diagram, a _______ attribute is one that can be derived from other attributes.