I have a Sybase IQ table with about 1 million rows. To improve performance, I need to add an index on the primary key which has over 900 distinct values. Which index type would I choose?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What is the default index that is being created when a table is created in Sybase IQ?
- Figure out the indexes which are not part of Sybase IQ?
- A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decre...
- In Sybase IQ, every column is treated as an index.
- You are preparing a new index on a table that has 1,500 rows. 10 rows are added to this table every day. Th...
- Which is correct about index?
- Which index is automatically created if you enable a UNIQUE KEY or PRIMARY KEY constraint
- You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key col...