22,209
社区成员
发帖
与我相关
我的任务
分享
--创建表
if OBJECT_ID('news') is not null
drop table news
create table news
(
news_id bigint primary key,
news_content varchar(8000),
news_datetime datetime
)
--为时间列建立索引
create index idx_datettime on news(news_datetime)
select news_datetime from news
where news_datetime between '2010-08-18 16:03' and '2010-08-18 16:04'
select * from news
where news_datetime between '2010-08-18 16:03' and '2010-08-18 16:04'
表'news'。扫描计数1,逻辑读取23045 次,物理读取0 次,预读0 次,lob 逻辑读取0 次,lob 物理读取0 次,
select * from news where news_id in(
select news_id from news
where news_datetime between '2010-08-18 16:03' and '2010-08-18 16:04')