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
>

Maintenance plans: online rebuilding of indexes...

I'm using SQL Server 2005 SP1 Standard.

On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'.

Great I thought, I'll check that.

Later, when I tested the job, I got this error:

'Online index operations can only be performed in Enterprise edition of SQL Server.'

Why have that checkbox available to check, if I'm running a version that doesn't allow it? Where's the bug?

Thanks

Ed

I've entered a bug in our tracking database.

Thanks,

Mark