I found lots of blog talk about the advantage of [include] index, for example, to avoid the Size Limits. But what's the advantage of composite index?
I created two tables with the same structure and data. table(a,b,c), and then created two indexes for each table index C_index on table1 (b,c) and index I_index on table2 (b) include (C). But I got the same execution plan all the time even if
the indexes are different. For example:
select B, C from table
select c from table where b =**
select b from table where c=**
select a from table where b=** and c=**
select a from table where c=** and b=**
i konw that the key columns are stored at all levels of the index, nonkey columns are stored only at the leaf level. But I cannot find an example to show the disadvantage compare to composite index. I must be missing something, but what's that?
View Complete Post