Re: How Oracle use an INDEX?

Hello,

Thanks both of you for giving time here.

BTW, I am using 8.1.6 on W2K Pro. And I am not using any explicit hints therefore explain plan shows the optimizer = "CHOOSE".

My only concern is the placement of columns in the where clause when using concatenated indexes. Suppose I have an index (a,b,c) then do I write

where a = 1, b= 2, c= 3

OR

where c= 3, b = 2, a = 1

i.e Do I start my where clause with the first index column or do I place this column in the very end and place the last index column as the first where clause column. The same will apply to order by clause as well, I think.

Finally, how do I know that Oracle is using all/what columns of a multi-column index?

TIA and Best Regards,
NK. Received on Thu Aug 16 2001 - 00:34:38 CDT