|
-
 Originally Posted by PAVB
Okay... so you have about 87K rows on your table and 86K unique keys on your candidate index on APPNM column; is that correct?
If that's correct the cheaper execution plan you can get is the one you have, FTS on your table.
If your row/key counts are substantially different please gather fresh stats and start again.
------
Thank You PAVB.
Sorry for bothering You but only quick question regarding this.
Someone has adviced me that creating materialized view and setting query rewrite may be good solution (this query is hardcoded in application - i can't change it).
What do you think about this ?
Best Regards Arek Masny
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