mysql 和sql server有什么工具或者方式可以 查看sql 執(zhí)行的次數(shù)

從主鍵還是索引取決于查詢條件,即where和order by后面的涉及的字段.可以用explain select xxx from your_table來看.

可以使用跟蹤優(yōu)化器看，或者workbench的可視化界面

# Turn tracing on (it's off by default):
SET optimizer_trace="enabled=on";
SELECT ...; # your query here
SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
# possibly more queries...
# When done with tracing, disable it:
SET optimizer_trace="enabled=off";