单选题
发布日期:2022-07-06
Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes
Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations
Drop the run_2 index because it has caused a conflict in the choice of key for this query
Execute the run_2 index because it has caused a conflict in the choice of key for this query
Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
标签: "暂无标签"
题王网让考试变得更简单
扫码关注题王,更多免费功能准备上线!
此试题出现在