Breaking News: Grepper is joining You.com. Read the official announcement!

reindex mssql table

Motionless Macaque answered on January 6, 2022 Popularity 4/10 Helpfulness 2/10

answer reindex mssql table

reindex mssql table

Comment

-- mssql use to determine what indexes need to be rebuilt
SELECT S.name as 'Schema',
T.name as 'Table',
I.name as 'Index',
DDIPS.avg_fragmentation_in_percent,
DDIPS.page_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id
INNER JOIN sys.schemas S on T.schema_id = S.schema_id
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id
AND DDIPS.index_id = I.index_id
WHERE DDIPS.database_id = DB_ID()
and I.name is not null
AND DDIPS.avg_fragmentation_in_percent > 0
ORDER BY DDIPS.avg_fragmentation_in_percent desc

Popularity 4/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: reindex sql

Link to this answer
Share Copy Link

Contributed on Jan 06 2022

Motionless Macaque

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

reindex mssql table

Contents

More Related Answers

reindex mssql table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.