顯示Sql執行效率,執行計劃
SET STATISTICS IO ON
SET STATISTICS TIME ON
SELECT * FROM C_setOrder where OrderNo='TCR0801854'
print '====================================='
SELECT * FROM C_setOrder where OrderNo in('TCR0801854')
SET STATISTICS IO ON
SET STATISTICS TIME ON
SELECT * FROM C_setOrder where OrderNo='TCR0801854'
print '====================================='
SELECT * FROM C_setOrder where OrderNo in('TCR0801854')