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!

Create index on date column

558311Aug 28 2007 — edited Aug 29 2007
Hi All,

I am trying to create an index on a date column for a table with about 40 milllion records. Here is query i am using

CREATE INDEX IDX_NAME ON TABLE_NAME(DATE_OF_SERVICE);

Is there anything that I can do to make the Index more efficient?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2007
Added on Aug 28 2007
11 comments
8,177 views