RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

SQL 2005 Best Practice Indexing Tuning

Rebuild Index:   Throws away the complete index and rebuilds it from scratch.This can be a long process but it is more complete then defrag/reorganize index. Best used if the fragmentation is heavy (over 30%). Can be done online in SQL2005 enterprise edition otherwise it means that the table is blocked during the rebuilding.Statistics are recalculated. Defragment\Riorganize Index:- Defrag/reorganize index : is faster then rebuild index but less complete.You can use it when index fr 
Leggi tutto il post...
Categoria: Sql Server ALL
venerdì, 08 feb 2008 Ore. 16.54

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003