Article View: cn.bbs.comp.database
Article #672Re: SQL Server Index Basics zz
From: 1/20
Date: Mon, 05 Jan 2009 06:44
Date: Mon, 05 Jan 2009 06:44
27 lines
2140 bytes
2140 bytes
������һ�仰�������� һ��˵ B�� ���������ϵ� B-�� http://en.wikipedia.org/wiki/B-tree �Ǹ�-�����ӷ��Ǽ��š� ��B-tree֮�����һЩvariants����B+ tree��B*-tree Binary tree�ͽж�������û��˵��B���� �� �� Dem (Galaxy��VOLUNTEERS��Database) �Ĵ������ᵽ: �� : SQL Server���������Ӧ����B-�� : ����B-��������˺���һ���Ǽǵú�����Ļ����Բο����ģ� : B ���� B- ���� B+ ���� B* ������ʲô : http://www.cppblog.com/qiujian5628/articles/42190.html : �㷨�λ��Ǻ����õġ����� : �� �� Dem (Galaxy��VOLUNTEERS��Database) �Ĵ������ᵽ: �� : : http://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/ : : One of the most important routes to high performance in a SQL Server : : database is the index. Indexes speed up the querying process by providing : : swift access to rows in the data tables, similarly to the way a book��s : .................������ʡ�ԣ� -- From the Random Shack Data Processing Dictionary: Endless Loop: n., see Loop, Endless. Loop, Endless: n., see Endless Loop. [m[1;34m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 149.171.224.68][m
Technical Details
Message-ID:
<4diBh9$aiX@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!news1.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,8729d6ba08f236f3 X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!news1.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Programmer.bbs@bbs.sjtu.edu.cn (1/20) Newsgroups: cn.bbs.comp.database Subject: Re: SQL Server Index Basics zz Date: 05 Jan 2009 06:44:31 GMT Organization: ��ˮ˼Դ Message-ID: <4diBh9$aiX@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1231137561.A