发布日期:2021-01-28
A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
B.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
C.Drop the run_2 index because it has caused a conflict in the choice of key for this query
D.Execute the run_2 index because it has caused a conflict in the choice of key for this query
E.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
热门试题
热门资讯
暂无相关推荐~
使用浏览器的分享功能,把这篇文章分享出去
确定