July 18, 2008 at 1:01 pm
guys,
I have quick question - our environment is a low volume OLTP environment with upto 400 rows updated/inserted/deleted in 40 tables every day.
In this environment would it be prudent to run the a job update index statistics on every table each week. Currently I update index statistics only when
I refresh the database with data (which is I trucnate all the data and run ETL program to load all the tables from source data).
Any suggestions and inputs would be helpful
Thanks
July 18, 2008 at 1:27 pm
Is the database running at acceptable speed? Users get their data in a timely way? If so, I wouldn't mess with the indexes. Not with what you're doing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply