Browse by Tags

• indexes
• performance
• sql server
• update statistics

Update Statistics on huge tables - best practice
23 October 07 04:40 AM | SQL Master | 2 Comments   

If you have valid indexes and they are maintained with regular schedule of reindexing to address fragmentation, then you can go with UPDATE STATISTICS on the tables that has frequent updates, say once in 2 days during the quiet time on the databases. Read More...

Filed under: performance, sql server, indexes, update statistics, best practice, indexed views