Confused.

Still little bit confused regarding Statistics updates and rebuilding
indexes.... can any one give me one basic difference.
I remember you, you asked few days ago:
http://groups.google.de/group/micros...0354ae6af6fdbc
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23MNB6NZVFHA.2272@.TK2MSFTNGP15.phx.gbl...
> Still little bit confused regarding Statistics updates and rebuilding
> indexes.... can any one give me one basic difference.
>
|||On Tue, 10 May 2005 15:07:43 -0400, Joh wrote:

>Still little bit confused regarding Statistics updates and rebuilding
>indexes.... can any one give me one basic difference.
>
Hi Joh,
Take a text book, or an SQL manual or something like that. The last
20-50 pages will probably contain an index, that you can use to find
that deadlocks are discussed on pages 574-577 and 893, and that the
SELECT statement is discussed on pages 34-108, 145-160, 254 and 664.
Tear out this index. Then, take a stack of blank paper, scan each page
of the text book and recreate the index. This activity is somewhat
equivalent to rebuilding an index.
Now, take a quick scan over the index. You might note that there are
less (or maybe more?) words in the index that start with 'A' then with
'B'. You'll probably note that there are almost no words with 'X', but
quite a lot starting with 'Q'. Assuming that you don't forget this
information, but use it next time you need to find an entry to locate
the correct page in the index quicker, then you have just performed the
equivalent of updating statistics.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Really appreciated Hugo... thanks
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:rd32819sm6p33mfnhk6l62eb03hc8pun25@.4ax.com...
> On Tue, 10 May 2005 15:07:43 -0400, Joh wrote:
>
> Hi Joh,
> Take a text book, or an SQL manual or something like that. The last
> 20-50 pages will probably contain an index, that you can use to find
> that deadlocks are discussed on pages 574-577 and 893, and that the
> SELECT statement is discussed on pages 34-108, 145-160, 254 and 664.
> Tear out this index. Then, take a stack of blank paper, scan each page
> of the text book and recreate the index. This activity is somewhat
> equivalent to rebuilding an index.
> Now, take a quick scan over the index. You might note that there are
> less (or maybe more?) words in the index that start with 'A' then with
> 'B'. You'll probably note that there are almost no words with 'X', but
> quite a lot starting with 'Q'. Assuming that you don't forget this
> information, but use it next time you need to find an entry to locate
> the correct page in the index quicker, then you have just performed the
> equivalent of updating statistics.
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
|||Thanks Jens... really appreciated.
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OwbMTXZVFHA.3716@.TK2MSFTNGP12.phx.gbl...
> I remember you, you asked few days ago:
>
http://groups.google.de/group/micros...ts/browse_frm/
thread/17a8f88d35626ce5/4b0354ae6af6fdbc?q=Jens+S%C3%BC%C3%9Fmeyer+differe nc
e+statistics+index&rnum=1&hl=de#4b0354ae6af6fdbc
> HTH, Jens Suessmeyer.
>
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23MNB6NZVFHA.2272@.TK2MSFTNGP15.phx.gbl...
>