In which scenario would you consider using a non-clustered index over a clustered index?
- When you frequently query a large range of values
- When you need to enforce a primary key constraint
- When you need to physically reorder the table data
- When you want to ensure data integrity
A non-clustered index is considered when you frequently query a large range of values or when you want to avoid the overhead of reordering the physical data in the table, which is required by a clustered index.
Loading...
Related Quiz
- Which of the following best describes a characteristic of NoSQL databases?
- Which of the following best describes the relationship between normalization and data redundancy?
- What is the difference between a Conformed Dimension and a Junk Dimension in Dimensional Modeling?
- In data cleansing, what does the term "data deduplication" refer to?
- Apache Hive provides a SQL-like interface called ________ for querying and analyzing data stored in Hadoop.