1. Database Practices
  2. Appendix
  3. Script to Check Histograms on FLEXCUBE Schema

Script to Check Histograms on FLEXCUBE Schema

Following script would have to be executed in the FLEXCUBE schema:
select distinct table_name
from
(
select table_name from user_tab_columns where histogram!='NONE'
)

Should return No Records

Parent topic: Appendix