See the following query:
select a from test where c=10;
Suppose we have a composite index on columns(c,a). Will all the data in this case be retrieved using index without actually referring the base table?
Results 1 to 6 of 6
Thread: Question about table scanThreaded View
|
Click Here to Expand Forum to Full Width |