What does it mean when CREATE INDEX

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Fri, 29 Mar 2013 19:05:04 -0300
Message-ID: <CAJdDhaNMUops+=7cG9nRWVWcTAGWH6Hjf6jqwoDjZ=VRZJpQRA_at_mail.gmail.com>



Hi Friends,
I saw a command like this:

CREATE INDEX emp_ename ON emp(ename desc, 1);

The benefit pointed of this solution is that when we use in the where clause

--> where name IS NULL

sometimes the optimizer does not use the index.

In the test that person did, using ... emp(name,desc,1) the optimizer used the index.

Does it apply to Oracle 11g ?

Did anybody have any experience using this resource ?

I will test it too.

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 29 2013 - 23:05:04 CET

Original text of this message