Friday, February 24, 2012

Indexes and Statistics

Hi,
Do I need to create statistic on a column that already has an index?
Thanks in advance,
LeilaNo.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Leila" <Leilas@.hotpop.com> wrote in message
news:OJU9AxzVGHA.4956@.TK2MSFTNGP09.phx.gbl...
Hi,
Do I need to create statistic on a column that already has an index?
Thanks in advance,
Leila|||The first column in the index already have statistics, with that index.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Leila" <Leilas@.hotpop.com> wrote in message news:OJU9AxzVGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do I need to create statistic on a column that already has an index?
> Thanks in advance,
> Leila
>|||Nope. The process of indexing does create the statistics in the background.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:OJU9AxzVGHA.4956@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Do I need to create statistic on a column that already has an index?
> Thanks in advance,
> Leila
>

No comments:

Post a Comment