Oracle Database Discussions

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!

skip scan

don123Dec 18 2018 — edited Dec 19 2018

I created composite index with column order (country_name, state_name, city_name) and skip scan is used.

To see if there is difference in response time of query, I reversed the column order (city_name, state_name, country_name).

The column order has no impact, using 11.2.0.3, is this OK ?

This post has been answered by KayK on Dec 18 2018

Jump to Answer

Added on Dec 18 2018

#general-database-discussions

7 comments

714 views