indexes out of date

What does it mean when they say indexes are out of date wrt the query
optmiser ? How do you keep them to date ? Kinda confusedSee Distribution Statistics in bol.
The statistics may be out of date so that the optimiser
does not have correct data on the data distribution of
data to select a plan.
Also indexes may get fragmented and need rebuilding.
>--Original Message--
>What does it mean when they say indexes are out of date
wrt the query
>optmiser ? How do you keep them to date ? Kinda confused
>
>.
>|||Hello Hassan !
Look here:
http://doc.ddart.net/mssql/sql70/tun_1_19.htm
Especially in "Auto update", or manual "UPDATE STATISTICS".
HTH, Jens Süßmeyer.|||We are also talking about regular index maintenance... look for dbcc
dbreindex, dbcc indexdefrag, and dbcc showcontig in books online. These
areas discuss other index tuning and maintenance which must be done.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OzEzlizbDHA.1488@.TK2MSFTNGP12.phx.gbl...
> What does it mean when they say indexes are out of date wrt the query
> optmiser ? How do you keep them to date ? Kinda confused
>