Quetion on Sybase Indexes

jvijay · #1 (**permalink**) 11-10-11, 04:59

Hi ,

For one of my large tables, we have a primary key on 5 columns (in the order A,B,C,D and E).

Is it ok to create another non unique index with few of the pimarry columns say D,E,C?

Will this help speed up the retrival of rows when searched on columns D,E and C? Or is this index redundant and overhead?

any help is much appreciated.

Thankns,
VJ.

pdreyer · #2 (**permalink**) 11-14-11, 08:02

Quote:

Originally Posted by jvijay

Hi ,

For one of my large tables, we have a primary key on 5 columns (in the order A,B,C,D and E).

Is it ok to create another non unique index with few of the pimarry columns say D,E,C?

Will this help speed up the retrival of rows when searched on columns D,E and C?

Yes

Quote:

Originally Posted by jvijay

is this index redundant and overhead?

No

Internet Services

Web Development

Digital Marketing

Consumer Tech