Horje
oracle table statistics Code Example
oracle table statistics 
SELECT ST.TABLE_NAME, ST.PARTITION_NAME, HIGH_VALUE, ST.NUM_ROWS, 
	   ST.BLOCKS, ST.LAST_ANALYZED
FROM DBA_TAB_STATISTICS ST
LEFT JOIN DBA_TAB_PARTITIONS PAR
ON PAR.TABLE_NAME = ST.TABLE_NAME AND PAR.PARTITION_NAME = ST.PARTITION_NAME
WHERE ST.OWNER = 'MY_OWNER'
  AND ST.TABLE_NAME = 'MY_TABLE'
ORDER BY PARTITION_NAME;



Sql

Related
sql group by error Code Example sql group by error Code Example
postgresql get last day of month Code Example postgresql get last day of month Code Example
how to check last gather stats on table in oracle Code Example how to check last gather stats on table in oracle Code Example
mysql backup skip table Code Example mysql backup skip table Code Example
woocommerce mysql price table Code Example woocommerce mysql price table Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 10



 

Horje