查询视图中大量数据时
select * from table where Time >= '2008-06-18 00:00:00' and Time <= '2008-06-18 23:59:59'
select * from (
select top 100000000000000 * from table order by Time )table1 where Time >= '2008-06-18 00:00:00' and Time <= '2008-06-18 23:59:59'
差别很大,在设计表或者视图的时候,结构的优化非常重要!