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:
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-lReceived on Fri Mar 29 2013 - 23:05:04 CET