Skip to Content
0
Oct 24, 2013 at 07:04 AM

Index Range Scan Performance & Column Order on Oracle 11g (11.2.0.2)

220 Views

Hello,

I have the following execution plan:

The WHERE clause actually has an equal condition for each colum of index /BIC/DWPFRM001B~01.

The index statistics look as follows:

I am wondering, if the execution of the statement would be faster, if the column order in the index is arranged in such a way, that the columns are ordered according to their selectivity, putting the most selective column (that is SID_WP00EXTI1) at first position.

Does the column order of an index really matter if all of the columns are queried with an equal condition?

If yes, what's the technical reason behind it?

Thanks for any help in advance!

Best regards,

Philipp

Attachments

Execution_Plan.jpg (78.5 kB)
Index_Info.jpg (64.0 kB)