What is the main property an index should have to ensure its efficiency?

The main property of an index to ensure its efficiency is uniqueness and selectivity. An index should allow for quick filtering of data, meaning it should have high selectivity — returning a small set of records compared to the total data volume. If an index covers a large number of rows, its efficiency decreases because searching through it will not be faster than a full scan.