Major difference.

What are the major difference b/w rebuilding indexes and update statistics
thanks
Statistics: http://www.mssqlcity.com/Articles/Adm/IndexStat70.htm
Preprocessing --> Statistics
Query --> Indexes to retrieves the result on the data pages
Simple example: You have serveral books whch contain from 1 to 1000000
words, If you are searching a word in the "one word book" you have to know
that it is not necessary to use the book index. Thats because you got your
own statistics in your mind to know "Thats a quite thin book, i rather
search side by side" or that book doesnt contain an index, so ill have to
run through the pages to find the word.
Thatl just a plain example i suggest you to read articles of one of the
best authors of indexes --> Kalen Delaney
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:Ol6EAKRRFHA.3988@.tk2msftngp13.phx.gbl...
> What are the major difference b/w rebuilding indexes and update statistics
> thanks
>