My requirement is
to quickly select records based on either the ID column or the LAST_NAME or both columns together from my table say 'T'
I want to create index on these two columns
Should I be creating
1 index specifying both columns, or
2 indexes (one on each), or
3 indexes (one for ID + one for last name + both)
Can you please advice ??
Thanks in advance
I'll start with one on each column.
Assuming ID column is unique the "two columns together" requirement will be serverd by the unique index on ID.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width