Article - CS203414

MS SQL Index Fragmentation Detect and Fix Script for Integrity Lifecycle Manager/PTC RV&S databases

Modified: 06-Feb-2025   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 2006 to 13.2
  • MS SQL Server

Description

  • KCS Article 000135655 provides a SQL statement that generates a list of fragmented indexes and statements to fix based on Microsoft SQL Server best practices
  • Is there a way to perform detection and correction of fragmented indexes on SQL Server as a single operation
This is a printer-friendly version of Article 203414 and may be out of date. For the latest version click CS203414