The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
dbtables.[object_id] = indexstats.[object_id]
dbtables.[schema_id] = dbschemas.[schema_id]
dbindexes.[object_id] = indexstats.[object_id]
indexstats.index_id = dbindexes.index_id
indexstats.database_id = DB_ID()
This query can be modified to focus on specific tables by append the table name to the 'where' clause:
indexstats.database_id = DB_ID() AND dbtables.[
] like '%%'
In order to reduce fragmentation we will have to reorganize or rebuild the indexes. Choosing between reorganizing or rebuilding depends on the query results.
For heavily fragmented indexes a rebuild process is needed, otherwise index reorganization should be sufficient.
The following table summarizes when to use each one:
|Reference Values (in %)||Action||SQL statement|
|avg_fragmentation_in_percent > 5 AND < 30||Reorganize Index||ALTER INDEX REORGANIZE|
|avg_fragmentation_in_percent > 30||Rebuild Index||ALTER INDEX REBUILD|
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!