If we have 5 fields in the primary key, do we have to create a index inorder to fetch the data only on one field?
Eg:- Primary Key contains field A,B,C,D and E
we have a select statement as given below
Select from table where a = S_a.
So do we need to create a secondary index on a to improve the performance? can you please guide me?