|
-
Hi Vijay - glad to hear from you.
Yes, I was referring to cardinality.
As I can see query is doing a range scan on index T1_INDX11 ... 13M rows, too many rows when compared with the 500 rows that are expected to be retrieved.
You may want to double-check indexing strategy, may be a new index more aligned with the queries predicate would help.
Last edited by PAVB; 10-12-2010 at 12:52 PM.
Reason: typo
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.
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