Sometimes you want to Drop the Histogram of a particular table and dont want to generate a histogram for a particular column in the table. let’s see how we can achieve it 11G and the above solution First of all, you can delete the existing histograms using the below command BEGIN dbms_stats.delete_column_stats( ownname=>'SCOTT', tabname=>'TEST', colname=>'UNIQ_ID', […]

The post How do I drop the histogram on a column and prevent to generate in future appeared first on Techgoeasy.