SELECT mobile FROM TABLE2 where mobile not in (select substring(tel,3,11) from get_table where time>=dateadd(dd,-30,getdate()))
这样查询很慢,如何提升一下效率呢?是SQL2000
...全文
1629打赏收藏
在查询中用no in慢的问题?
SELECT mobile FROM TABLE2 where mobile not in (select substring(tel,3,11) from get_table where time>=dateadd(dd,-30,getdate())) 这样查询很慢,如何提升一下效率呢?是SQL2000