Saturday, February 6, 2010

Display fragmentation info on data and indice of a table

Use DBCC SHOWCONTIG statement on heavily modified tables or tables that contain imported data or tables that make the query performance very poor.

DECLARE @TableId INT
SET @TableId = OBJECT_ID('Your table name')
DBCC SHOWCONTIG(@TableId);

No comments:

Post a Comment

Oracle Query