What is the difference between a clustered index and a non-clustered index in an RDBMS?
- Contains only key columns and row locators
- Determines the order of data rows on disk
- Has a higher level of fragmentation compared to clustered
- Stores a separate copy of the table data
A clustered index in an RDBMS determines the order of data rows on disk, physically rearranging the data rows according to the index key. In contrast, a non-clustered index stores a separate copy of the index key columns along with row locators, maintaining a logical ordering of data without altering the physical order.
Loading...
Related Quiz
- In Kafka, the ________ is responsible for storing the committed offsets of the consumers.
- What is the primary objective of data extraction in the context of data engineering?
- What is the primary difference between batch processing and streaming processing in pipeline architectures?
- How does data warehousing differ from traditional relational database systems?
- Which component of Kafka is responsible for storing the published messages?