|
 |
|
| | Identifying Which Indexes to Rebuild. |
| Автор: Don Burleson |
Источник: н/д | Язык: английский |
| Indexes require rebuilding when deleted leaf nodes appear or when the index has spawned into too many levels of depth. While it is tempting to write a script that rebuilds every index in the SAPR3 schema, bear in mind that SAP contains many thousands of indexes, and a complete rebuild can be very time consuming. Hence, we need to develop a method to identify those indexes that will get improved performance with a rebuild. Let’s look at a method for accomplishing this task. |
| Доступные файлы (отрапортовать об ошибке!): |
|
Просмотреть
Загрузить
В портфель! (руководств: 0)
Обсудить на форуме
|
|
|
 |
|