Multiple choice

Which table type should be used to provide fast key-based access to table data for queries involving exact matches and range searches?

  1. Regular table

  2. Clustered table

  3. Partitioned table

  4. Index-organized table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Index-organized tables (IOTs) store rows in B-tree index structure sorted by primary key, providing fast key-based access for both exact matches and range searches. Regular tables store rows in heap format, clustered tables group related tables together physically, and partitioned tables divide data into segments but don't optimize key-based access specifically.

Keep practicing — related questions