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!

index tuning help

3193178Apr 8 2016 — edited Apr 8 2016

we have a large table that i need to index.

here are the columns:

phone_number,

state,

revision_number,

data_month_year,

account_number,

File_date

I am assuming I shouldn't create an index for each column, should I?

The users will use any combination of these or maybe just one column in their where clause.

If i try to group them together, it may be something like:

date_month_year

or date_month_year & state & revision_number,

or date_month_year & phone_number

or date_month_year & account_number

State & file_date

or maybe all of them together?

thoughts on indexing, thanks.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2016
Added on Apr 8 2016
5 comments
183 views