我的表(a,b,c,d)四列都依赖于列(日期),所以我在查询中有: , w3 l+ R4 |9 K" D$ Y select a where date select b where date select c where date select d where date我需要知道为所有索引创建索引的最佳方法是什么。我有两个建议: + e; m, x2 n o( W) a第一个建议: ' e$ r9 O( k% U/ Z, c4 ?1 D+ tcreate i_a on acreate i_b on bcreate i_c on ccreate i_d on dcreate i_date on date第二个建议: % h. S4 i; `) z A2 Ncreate i_a on a include datecreate i_b on b include datecreate i_c on c include datecreate i_d on d include date哪个更好? 7 |; O$ R! d) L3 N/ w * b' {; [$ H4 n8 i解决方案: # | M; m8 E+ ?2 m8 P/ A( A
这可能对你有帮助:2 l% k; a6 W/ M/ `- f7 ^4 S) ^
CREATE NONCLUSTERED INDEX Index_Name ON TableName(Date) INCLUDE(A,B,C,D)索引列应用于过滤(WHERE子句)。您可以添加它INCLUDE避免查询。