REBUILD

What is the recommandation like how frequently we need to rebuild the
indexes, every day ?
Thanks
That depends on many thing:
-How often they change
-How the workload is
-Fragmentation
.....
You have to name some key data to give a recommondation.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23Xixv2QRFHA.3704@.TK2MSFTNGP12.phx.gbl...
> What is the recommandation like how frequently we need to rebuild the
> indexes, every day ?
> Thanks
>
|||What would be more good... Update Statistics, Rebuild Indexes or
Fragmentation ?
thanks
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:#9haPCRRFHA.3144@.tk2msftngp13.phx.gbl...
> That depends on many thing:
> -How often they change
> -How the workload is
> -Fragmentation
> ....
> You have to name some key data to give a recommondation.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23Xixv2QRFHA.3704@.TK2MSFTNGP12.phx.gbl...
>
|||Thats all nice, Statistic are good for preprocessing the query, rebuilding
indexes and defragmetation keep up the fast scanning.
HTH, Jens Suessmeyer.
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:OF5SkIRRFHA.3048@.TK2MSFTNGP10.phx.gbl...
> What would be more good... Update Statistics, Rebuild Indexes or
> Fragmentation ?
> thanks
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:#9haPCRRFHA.3144@.tk2msftngp13.phx.gbl...
>
|||Can you more explain about Statistics.
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:u3PbNLRRFHA.1564@.TK2MSFTNGP09.phx.gbl...
> Thats all nice, Statistic are good for preprocessing the query, rebuilding
> indexes and defragmetation keep up the fast scanning.
> HTH, Jens Suessmeyer.
>
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:OF5SkIRRFHA.3048@.TK2MSFTNGP10.phx.gbl...
>
|||If Reindexing and Defragmentation have the same functionality then why we
have to go for both, why not for any specific... ?
"Joh" <joh@.mailcity.com> wrote in message
news:#Xixv2QRFHA.3704@.TK2MSFTNGP12.phx.gbl...
> What is the recommandation like how frequently we need to rebuild the
> indexes, every day ?
> Thanks
>