Avoiding Index Maintenance Rebuilds
Guardado en:
| Publicado en: | SQL Server Magazine vol. 13, no. 12 (Dec 2011), p. 11. |
|---|---|
| Autor principal: | |
| Publicado: |
Informa
|
| Materias: | |
| Acceso en línea: | Citation/Abstract Full Text Full Text - PDF |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| Resumen: | How can that be if I'm checking the fragmentation using SQL Server's Dynamic Management Views (DMVs)? The problem can affect nonclusiered and clustered indexes, and unless you're actively keeping !rack of when the fragmentation threshold triggers he maintenance routine to rebuild an index, you'll never know that you have the problem. |
|---|---|
| ISSN: | 1522-2187 2165-3291 |
| Fuente: | Advanced Technologies & Aerospace Database |