我的数据表里总共有700条数据,为什么用“SELECT count(*) FROM [ContractChangeSearchView] WHERE ApplictionType is not NULL AND CreationDate >= '2011-3-25' AND CreationDate <= '2011-4-16' ”这条语句查询确需要三分钟这么长的时间,而查询的结果只有70条数据?
SELECT count(*) FROM [ContractChangeSearchView] WHERE ApplictionType is not NULL AND CreationDate >= '2011-3-25' AND CreationDate <= '2011-4-16一句一句分析,先把条件去掉,在creationDate上建索引
不行啊,我用“SELECT * FROM [ContractChangeSearchView] WHERE ApplictionType is not NULL AND (CreationDate between '2011-3-14' AND '2011-4-16')”得到的结果所需要的时间依然很长
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货