-
indexes
Hello Gurus
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'
For this
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|