Querying table index stats not working

Question

I am trying to query my tables index fragmentation in Azure Synapse studio with query:

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

But i get error:

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

How to fix?

Answer 1

If you look at the topic for sys.dm_db_index_physical_stats, you will see this:

That is, this is DMV is not available on Synapse. I don't know how you check for fragmentation on Synapse, but it is a different engine from the regular SQL Server, so I don't even know how application the concept of fragmentation is to Synapse.