Skip to Content
0
Former Member
May 02, 2006 at 01:11 PM

Creating secondary Index . Performance tuning

220 Views

Hi,

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?

thank you,

Lijo Joseph