?? 原始速度.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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -