A ________ index includes additional columns beyond those in the index key, allowing queries to be answered directly from the index without having to access the table data.
- Clustered
- Composite
- Non-clustered
- Unique
A composite index includes additional columns beyond those in the index key, allowing queries to retrieve necessary data directly from the index without accessing the table data, enhancing query performance.
Loading...
Related Quiz
- Which streaming processing architecture provides fault tolerance and guarantees exactly-once processing semantics?
- Scenario: Your company needs to process large volumes of log data generated by IoT devices in real-time. What factors would you consider when selecting the appropriate pipeline architecture?
- ________ is a NoSQL database that is optimized for high availability and partition tolerance, sacrificing consistency under certain circumstances.
- Apache Spark leverages a distributed storage system called ________ for fault-tolerant storage of RDDs.
- In a cloud-based data pipeline, ________ allows for dynamic scaling based on workload demand.