SELECT top 1 pt.* FROM t1where id='20180731223014'
SELECT top 1 pt.* FROM t1where id='0180731223014 ---字段值没加单引号导致了索引扫描
SELECT top 1 pt.* FROM t1where id='20180731223014'
SELECT top 1 pt.* FROM t1where id='0180731223014 ---字段值没加单引号导致了索引扫描
转载于:https://www.cnblogs.com/guochunyang2004/p/9407378.html