[edit]
1 IP豌襴 蠍磯蓋 #
一 IP 轟 覓語 一危磯. 螳螳 襴 蟲覲 螻, 覓語伎伎襷 覯 譟壱 觜蟲蠍磯 襷れ 蟾る´. 蠏碁覩襦 襷 襦蠏碁 IP(覓語) <-> IP(4byte unsigned int) 譟壱襯 螳讌螻 蟆曙郁 襷 . 讌襷 mssql server (varchar(40) 覲伎 mssql 企手 螳蟆) unsigned int螳 朱襦 bigint . 伎 一危磯 れ螻 螳 朱 れ 螳 .
![[http]](/moniwiki/imgs/http.png)
IP蟯 谿瑚蠍 覦.
覓語IP IP ------------- ------- '58.16.0.0' 4154 ... ... ...襦螳 覲
IP蟯 谿瑚蠍 覦. [edit]
2 覦覯 #
覦覯 2螳讌.
- 覦覯1: IP, 譬襭IP
- 覦覯2: IP
覦覯1 覃 IP企 蠍郁 朱 譴企. 讌襷 覦覯1襯 螳る 覈螳讌 譴蟆 螳 譯殊伎 蟆 . れ 蠏 螻れ企.
- 覯蟆 企至 蟆瑚? (一危壱 蟆一)
- 碁煙る 企至 り伎 觜襯瑚? (IP + 譬襭IP?? 譬襭IP + IP??)
- 覯一一 譟郁唄 磯ジ I/O 谿 覓語?
create table test( b int, e int ); declare @i int; set @i = 0; while(@i < 100000) begin insert test values(@i, @i + 10); set @i = @i + 11; end; create index a on test(b, e); create index d on test(e, b); set nocount on select * from test where 10000 between b and e; select * from test where 20000 between b and e; select * from test where 30000 between b and e; select * from test where 40000 between b and e; select * from test where 50000 between b and e; select * from test where 60000 between b and e; select * from test where 70000 between b and e; select * from test where 80000 between b and e; select * from test where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 7, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 10, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 12, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 15, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 13, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 10, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 8, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */
1襷譴 譴螳 5襷 螳蟾 讌襦 I/O 讀螳 蟆 覲 . 碁煙るゼ 企 蟆 磯讌 誤 覲伎語. a碁煙るゼ 磯り d碁煙るゼ 磯 蟆 覲 . れ 企蟾?
select top 1 * from test where 10000 between b and e; select top 1 * from test where 20000 between b and e; select top 1 * from test where 30000 between b and e; select top 1 * from test where 40000 between b and e; select top 1 * from test where 50000 between b and e; select top 1 * from test where 60000 between b and e; select top 1 * from test where 70000 between b and e; select top 1 * from test where 80000 between b and e; select top 1 * from test where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 7, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 10, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 12, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 15, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */
轟危 覦蟆. 朱 覲企る I/O螳 譴. 讌襷 螳 a碁煙るゼ 磯り d碁煙るゼ 磯 蟆 覲 . 轟 碁煙り 襷 譟郁 蟆手?
碁煙 譟郁 覓語 蟆朱 覲伎碁. 蠏碁 れ螻 螳朱 企蟾?
DBCC SHOWCONTIG ('dbo.test')
DBCC SHOWCONTIG(螳) 'test' 企 蟆 譴...
企: 'test'(325576198); 碁煙 ID: 0, 一危磯伎 ID: 12
TABLE 譴 蟆 給.
- 蟆 伎................................: 21
- 蟆 旧ろ ..............................: 4
- 旧ろ れ豺..............................: 3
- 旧ろ碁 蠏 伎 ........................: 5.3
- 蟆 覦[豕:れ].......: 75.00% [3:4]
- 旧ろ 蟆 譟郁 ...................: 25.00%
- 伎 螳ロ 蠏 覦危 .....................: 736.6
- 蠏 伎 覦(豌).....................: 90.90%
DBCC ろ 襭給. DBCC る 覃讌襯 豢ロ覃 ろ 蟯襴蟆 覓語.
select top 1 * from test with(index(d)) where 10000 between b and e;
select top 1 * from test with(index(d)) where 20000 between b and e;
select top 1 * from test with(index(d)) where 30000 between b and e;
select top 1 * from test with(index(d)) where 40000 between b and e;
select top 1 * from test with(index(d)) where 50000 between b and e;
select top 1 * from test with(index(d)) where 60000 between b and e;
select top 1 * from test with(index(d)) where 70000 between b and e;
select top 1 * from test with(index(d)) where 80000 between b and e;
select top 1 * from test with(index(d)) where 90000 between b and e;
/*
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
*/
一!! 蟲螳 襦 豕 I/O襯 讌螻 覈旧企. IP + 譬襭IP 企ろ磯 碁煙る朱 企蟾?
{{{
create clustered index c on test(b, e);
select top 1 * from test with(index(c)) where 10000 between b and e;
select top 1 * from test with(index(c)) where 20000 between b and e;
select top 1 * from test with(index(c)) where 30000 between b and e;
select top 1 * from test with(index(c)) where 40000 between b and e;
select top 1 * from test with(index(c)) where 50000 between b and e;
select top 1 * from test with(index(c)) where 60000 between b and e;
select top 1 * from test with(index(c)) where 70000 between b and e;
select top 1 * from test with(index(c)) where 80000 between b and e;
select top 1 * from test with(index(c)) where 90000 between b and e;
/*
企 'test'. 蟆 1, 朱Μ 所鍵 3, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 6, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 8, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 10, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 12, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 14, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 16, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 18, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
企 'test'. 蟆 1, 朱Μ 所鍵 20, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0.
*/
譟郁 譟蠍磯 讌襷 豕 . 手? 伎 れ螻 螳.select * from test with(index(a)) where 90000 between b and e; --b <= 90000 : 9襷蟇 --> 9襷蟇伎 e <= 90000 譟郁唄 蟆 select * from test with(index(d)) where 90000 between b and e; --e >= 90000 : 1襷蟇 --> 1襷蟇伎 b >= 90000 譟郁唄 蟆 select top 1 * from test with(index(a)) where 90000 between b and e; select top 1 * from test with(index(d)) where 90000 between b and e; -- 貎朱Μ襯 覲 SQL Server 碁煙 譟郁唄(碁煙れ 貉る) -- 襦 谿城 蟆 . -- 蠏碁覩襦 譬襭 + 襦 碁煙る -- 覦襦 螳 谿場 朱襦 TOP 1 蟆曙 れ 覦襦 覃豢覩襦 I/O 谿願 .
碁煙り 襷 る?
drop index test.c create clustered index c on test(b); select top 1 * from test with(index(c)) where 10000 between b and e; select top 1 * from test with(index(c)) where 20000 between b and e; select top 1 * from test with(index(c)) where 30000 between b and e; select top 1 * from test with(index(c)) where 40000 between b and e; select top 1 * from test with(index(c)) where 50000 between b and e; select top 1 * from test with(index(c)) where 60000 between b and e; select top 1 * from test with(index(c)) where 70000 between b and e; select top 1 * from test with(index(c)) where 80000 between b and e; select top 1 * from test with(index(c)) where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 2, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 7, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 9, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 11, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 13, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 15, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 17, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 19, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 22, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */ drop index test.c create clustered index c on test(e); select top 1 * from test with(index(c)) where 10000 between b and e; select top 1 * from test with(index(c)) where 20000 between b and e; select top 1 * from test with(index(c)) where 30000 between b and e; select top 1 * from test with(index(c)) where 40000 between b and e; select top 1 * from test with(index(c)) where 50000 between b and e; select top 1 * from test with(index(c)) where 60000 between b and e; select top 1 * from test with(index(c)) where 70000 between b and e; select top 1 * from test with(index(c)) where 80000 between b and e; select top 1 * from test with(index(c)) where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 2, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */ drop index test.c create clustered index c on test(b); select * from test with(index(c)) where 10000 between b and e; select * from test with(index(c)) where 20000 between b and e; select * from test with(index(c)) where 30000 between b and e; select * from test with(index(c)) where 40000 between b and e; select * from test with(index(c)) where 50000 between b and e; select * from test with(index(c)) where 60000 between b and e; select * from test with(index(c)) where 70000 between b and e; select * from test with(index(c)) where 80000 between b and e; select * from test with(index(c)) where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 7, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 9, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 11, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 13, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 15, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 17, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 19, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 22, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */ drop index test.c create clustered index c on test(e); select * from test with(index(c)) where 10000 between b and e; select * from test with(index(c)) where 20000 between b and e; select * from test with(index(c)) where 30000 between b and e; select * from test with(index(c)) where 40000 between b and e; select * from test with(index(c)) where 50000 between b and e; select * from test with(index(c)) where 60000 between b and e; select * from test with(index(c)) where 70000 between b and e; select * from test with(index(c)) where 80000 between b and e; select * from test with(index(c)) where 90000 between b and e; /* 企 'test'. 蟆 1, 朱Μ 所鍵 22, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 1, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 20, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 4, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 18, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 16, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 14, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 12, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 10, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 8, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. 企 'test'. 蟆 1, 朱Μ 所鍵 5, 覓朱Μ 所鍵 0, 覩碁Μ 所鍵 0, LOB 朱Μ 所鍵 0, LOB 覓朱Μ 所鍵 0, LOB 覩碁Μ 所鍵 0. */
蟆磯朱 e(譬襭殊)襷 碁煙り 朱 . clustered index covered index襯 る 譬襭殊+殊襦 碁煙るゼ 襷る .
鏤