A community member has associated this post with a similar question:
Querying table index stats not working

Only moderators can edit this content.

Synapse Dedicated pool index stats

Jani Hämäläinen 40

I try to get the fragmentation of my indexes with code

SELECT IPS.Index_type_desc, 
      IPS.avg_fragmentation_in_percent, 
      IPS.avg_fragment_size_in_pages, 
      IPS.avg_page_space_used_in_percent, 
      IPS.record_count, 
      IPS.ghost_record_count,
      IPS.fragment_count, 
      IPS.avg_fragment_size_in_pages
   FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL , 'DETAILED') AS IPS

How ever this gives me error

Parse error at line: 9, column: 40: Incorrect syntax near 'DB_ID'

Why does this not work?

PRADEEPCHEEKATLA-MSFT 82,356 Reputation points Microsoft Employee

2024-06-17T06:03:27.2+00:00

Duplicate of thread: https://learn.microsoft.com/en-us/answers/questions/1696365/querying-table-index-stats-not-working

Share via

Synapse Dedicated pool index stats