Is there a way to rebuild\defrag multiple table indexes in Toad for SQL Server that are about 30% or more degramented? Toad for SQL Server does not show which indexes are highly fragmented via percentage in any of the details.
There's no way to rebuild selected indexes based on the most fragmented.
WORKAROUND:
Use the following query to determine which indexes are 30% fragmented or greater:
SELECT
object_name(a.object_id) [TableName]
,a.index_id
,name [IndexName]
,avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
(
DB_ID()
, NULL , NULL, NULL, NULL
) AS a
JOIN sys.indexes AS b
ON a.object_id = b.object_id AND a.index_id = b.index_id
where a.avg_fragmentation_in_percent>30
STATUS:
Enhancement request number “TSS-204” has been submitted to Development for consideration in a future release of Toad for SQL Server.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center