|
-
-----------------------------------------------
only one of the columns are used for fetching
-----------------------------------------------
Ur tactict should be in using FAST SCAN ON INDEX
then u may:
have to use B+ index on " 4 major WHERE cols + 1 column that using for fetching (probaply it have to be last if list of fields)
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
|
Reply With Quote