Ms sql server sql优化技巧 

SET   STATISTICS   PROFILE   ON
SET   STATISTICS   IO   ON
SET   STATISTICS   TIME   ON
SELECT * FROM userinfo WHERE Name IS NOT  NULL AND  Name = '刘'
SELECT * FROM userinfo WHERE   Name = '刘'
SET   STATISTICS   PROFILE   OFF
SET   STATISTICS   IO   OFF
SET   STATISTICS   TIME   OFF

　　

posted @ 2014-11-26 15:48  ICupid  阅读(229)  评论(0)  编辑  收藏  举报