Top Histograms queries in Oracle
Here are some frequently used queries for histograms in Oracle How to check the endpoint values for the histograms SELECT ENDPOINT_NUMBER, ENDPOINT_VALUE, COLUMN_NAME FROM DBA_HISTOGRAMS WHERE TABLE_NAME=’&table_name’ AND owner=’&owner’; How to check the type of histogram created select COLUMN_NAME,NUM_DISTINCT,NUM_BUCKETS,HISTOGRAM from DBA_TAB_COL_STATISTICS where table_name=’&table_name’ and owner=’&table_owner’ order by column_name; How to check details for the frequency …
Top Histograms queries in Oracle Read More »