Link to home
Start Free TrialLog in
Avatar of shanng
shanng

asked on

SQL Server 2005 - reindex

Is it true that I need to reindex SQL2005 database frequently (eg daily), depending on how frequently the database is being access, database size and modification?
( no working experience for SQL2005 )
For Foxpro, I normally don't reindex my database so often, but pack maybe, to reduce the size.

Please advise on SQL2005 database maintenance, regarding to speed factor.
Or any website that provide useful information.
Thank you



SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of shanng
shanng

ASKER

What do you meant by "indexed columns are alot modified" ?
Please explain more.
Thanks




ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>What do you meant by "indexed columns are alot modified" ?
if you do alot of UPDATEs with the value of the indexed column(s) that get modified.