语句:先执行
--sqlserver 查看查询用时信息
SET STATISTICS IO ON
SET STATISTICS TIME on
--mysql
SET profiling=1;
SHOW profiles;
在执行你的sql语句
select * from table1;
select * from table2;
查看结果
语句:先执行
--sqlserver 查看查询用时信息
SET STATISTICS IO ON
SET STATISTICS TIME on
--mysql
SET profiling=1;
SHOW profiles;
在执行你的sql语句
select * from table1;
select * from table2;
查看结果