Multiple choice technology databases

Give the number of distinct values that LF index can hold

  1. 5000

  2. 10000

  3. 3000

  4. 1500

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Sybase IQ, a Low Fast (LF) index is designed for columns with low cardinality. By default, it is optimized to support up to 10,000 distinct values, making the stored choice correct and others incorrect.