我想优化这个选择查询:
Select Dane1, Dane5, Dane6, Dane7 FROM Test
INNER JOIN Test2 ON Test.Id=Test2.IdTest
WHERE Dane5 > 199850
我的数据库有2个表:test和test2:
test设计: Id int -> PRIMARY KEY, Dane1 int, Dane2 int, Dane3 int, Dane4 int, Dane5 int,
test2设计: Id int -> PRIMARY KEY, Dane6 int, Dane7 int, IdTest int,
默认索引:PK__test__7C8480AE(聚集),PK__test2__7E6CC920(聚集)
问题是: 应该添加或删除哪些索引?