Index

12 Jan 2006 9:31 AM

Guru

Hi all

How to findout which column(s) in the tables requires index. Any method to
follow??

Thanks in avance
Guru

12 Jan 2006 9:41 AM

Uri Dimant

Hi
http://www.sql-server-performance.com/clustered_indexes.asp
http://www.sql-server-performance.com/covering_indexes.asp
http://www.sql-server-performance.com/nonclustered_indexes.asp

Show quote

"Guru" <G***@discussions.microsoft.com> wrote in message
news:B8BB3531-834F-4DCA-8AFB-482559E1BF8F@microsoft.com...
> Hi all
>
> How to findout which column(s) in the tables requires index. Any method to
> follow??
>
> Thanks in avance
> Guru

12 Jan 2006 1:10 PM

Wayne Snyder

Also read Books on Line about the Index Tuning Wizard.

--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

Show quote

"Guru" wrote:

> Hi all
>
> How to findout which column(s) in the tables requires index. Any method to
> follow??
>
> Thanks in avance
> Guru