|
-
No, columns in these two indexes are totally different.
And I'm not going by number of columns in the indexes. Sorry if that led to any misunderstanding.
Based on the nature of data, I know that INDX_1 is more selective than INDX_2.
And whatever it may be, RBO should not know anything @ the 'selectivity' of an index. Still the plan changed after the reorg !!
svk
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
|