原始速度.sql

本代码简单明了

create table Test
(
    bookid int,
    bookName varchar(20),
    bookPrice int,
    bookProductName varchar(20)
)

delete from test
----
set nocount on  --提高执行时间30%--50%
declare @bid int
declare @bName varchar(20)
declare @bPrice int
declare @bpName varchar(20)
set @bid = 1

while @bid < 10000
begin
    set @bid = @bid + 1
    set @bName = 'ACCP' + convert(varchar(10),@bid)
    set @bPrice = @bid
    set @bpName = 'APTECH' + convert(varchar(10),@bid)
    insert into Test values(@bid,@bName,@bPrice,@bpName)
end


--create index 
create clustered index bookid
on test(bookProductName)

drop index test.bookid

select * from test where bookid= 8000

select * from test where bookProductName like 'APTECH8000'

--原始时间

0.076
0.011
--booid
0.076
0.011
--bookProductName
0.006
0.00008