SELECT
    dbschemas.[name] as 'Schema',
    dbtables.[name] as 'Table',
    dbindexes.[name] as 'Index',
    indexstats.avg_fragmentation_in_percent,
      indexstats.avg_page_space_used_in_percent ,
    indexstats.page_count,
      indexstats.*
FROM
    sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) AS indexstats
INNER JOIN
    sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id]
INNER JOIN
    sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id]
INNER JOIN
    sys.indexes dbindexes on dbindexes.[object_id] = indexstats.[object_id]
    AND indexstats.index_id = dbindexes.index_id
WHERE
    indexstats.database_id = DB_ID()
    AND indexstats.avg_fragmentation_in_percent > 20 -- Filtern von Indizes mit geringer Fragmentierung
      and indexstats.page_count > 1000
ORDER BY
    2, indexstats.avg_fragmentation_in_percent DESC;