Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is the order of the columns in an index important

485654Aug 13 2008 — edited Aug 13 2008
Hi,

i have an index with two columns.
Both columns define the unique index.

Now my index is Column B, Column A.

Column A is more selective than Column B. Is there a different, if i change the columns in the index? Index Column A, Column B

Both Columns are used in a where condition in a select-statement.

Thanks
Wolfgang
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2008
Added on Aug 13 2008
4 comments
859 views