Article View: cn.bbs.comp.database
Article #670Re: SQL Server Index Basics zz
From: Galaxy��VOLUNTEERS��Database
Date: Mon, 05 Jan 2009 05:47
Date: Mon, 05 Jan 2009 05:47
25 lines
2142 bytes
2142 bytes
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 : index helps you find information quickly within that book. In this article, : I provide an overview of SQL Server indexes and explain how they��re : defined within a database and how they can make the querying process : faster. Most of this information applies to indexes in both SQL Server 2005 : and 2008; the basic structure has changed little from one version to the : next. In fact, much of the information also applies to SQL Server 2000. : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;37m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.29][m
Technical Details
Message-ID:
<4diAOj$aWg@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,8729d6ba08f236f3,start X-Google-Attributes: gid101948,domainid0,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: SQL Server Index Basics zz Date: 05 Jan 2009 05:47:37 GMT Organization: ��ˮ˼Դ Message-ID: <4diAOj$aWg@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1231134381.A Lines: 24