[SAP HANA] Row Store Table Ratio

 

 

 SELECT
  HOST,
  PORT,
  CASE WHEN (((SUM(FREE_SIZE) / SUM(ALLOCATED_SIZE)) > 0.30)
 AND SUM(ALLOCATED_SIZE) > TO_DECIMAL(10)*1024*1024*1024)
THEN 'TRUE'
ELSE 'FALSE'
END "Row store Reorganization Recommended",
  TO_DECIMAL( SUM(FREE_SIZE)*100 / SUM(ALLOCATED_SIZE),
  10,
 2) "Free Space Ratio in %",
 TO_DECIMAL( SUM(ALLOCATED_SIZE)/1048576,
  10,
  2) "Allocated Size in MB",
 TO_DECIMAL( SUM(FREE_SIZE)/1048576,
  10,
  2) "Free Size in MB"
FROM M_RS_MEMORY
WHERE ( CATEGORY = 'TABLE'
 OR CATEGORY = 'CATALOG' )
AND PORT LIKE '%03'
GROUP BY HOST,
  PORT
;