Multiple choice technology databases

Numeric columns are best suited to define an index (for faster access)

  1. True

  2. False

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

Numeric columns generally make good index candidates because they are typically compact, fixed-width, and allow efficient comparisons. Numeric indexes enable fast range scans and sorting operations. However, this is not universally true - the selectivity of the column and query patterns matter more. Low-cardinality numeric columns like boolean flags may not benefit from indexing. But as a general principle, numeric columns are well-suited for indexes.