Thread: Matching Columns For A Index
04-21-08, 17:18 #1Registered User
- Join Date
- Jan 2008
Unanswered: Matching Columns For A Index
How can i know the matching columns in a index seeing the explain output.Suppose there is a index on C1,C2,C3 how can we know the MC(matching columns) that are matched for a predicate..Whether it is C1 or C2 or C1,C2???
Also how can we accurately calculate the index slice???