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 a conditional index

Murray SobolNov 15 2012 — edited Nov 16 2012
Can I create a conditional index.

For example, if column 1 is not null, create an index on column 1, column 2 and column 3.

If column is null, i do not want to create an index.

In the above example, data can from 2 sources; when column 1 is populated I know the source of the data so creating an index would be beneficial.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2012
Added on Nov 15 2012
9 comments
677 views