Skip to Content
0
Former Member
Sep 01, 2009 at 08:55 AM

How to change secondary index to primary index while selection

33 Views

hi,

I am seeing the secondary index used in selection for mseg table (in trace i can see that)but i want to use primary index.Can anyone suggest how to use primary index.

I have used all primary keys fields and seconadry index fields in the select statment.

Regards,

Thanigaiarasu