Using column prefix indexing helps reduce
A.
The amount of time to write a query
B.
The number of results returned
C.
The amount of disk I/O needed
D.
The amount of disk space needed
Explanation:
smaller index means more indices can be stored in the index cache at the one time.
— Also shorter index to store in index table as not full length of original column and all indexes are same length.