Skip to Main Content

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 A and A + B and A+B+C

s197oo302Apr 3 2014 — edited Apr 3 2014

This is index question.

If you have oracle database, and have the index A + B + C colume.

You might need the index A+ B or A.

Oracle Database automatically check these case and prevent these case,

So can save disk space and prevent not using original A+ B+ C index.

What is your opinion?

If This is the right scenario we might ask oracle to make constraint on index creation.

So we only have one index A+B+C. and probibit creating A+B or A by mistake.

Give your opinion.

Xie Xie

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2014
Added on Apr 3 2014
4 comments
230 views