HANA Tables LargestTables

DB02->大表里显示的表占用内存不是实时的，有可能清空日志表后这里的数据没有刷新，使用sql editor或者直接在HANA SQL 里执行以下语句

WITH 

/* 

[NAME]

- HANA_Tables_LargestTables_2.00.040+

[DESCRIPTION]

- Overview of largest tables (including indexes and LOBs)

[SOURCE]

- SAP Note 1969700

[DETAILS AND RESTRICTIONS]

- M_TABLE_LOB_STATISTICS available with Rev. 1.00.120
- WITH clause does not work with older DBACOCKPIT transactions before SAP BASIS 7.02 SP16 / 7.30 SP12 / 7.31 SP12 / SAP_BASIS 7.40 SP07 (empty result returned) 
- Tables < 1 MB are not considered to avoid high name mapping overhead
- Persistent memory columns available with Rev. 2.00.030
- M_TABLE_LOB_STATISTICS.MEMORY_SIZE available with Rev. 2.00.040
- May run significantly longer than previous versions because on-the-fly calculation of
  M_TABLE_LOB_STATISTICS.MEMORY_SIZE is quite expensive

[VALID FOR]

- Revisions:              >