rkolluru's picture
Company:
Country:
Personal Website:
Day Job:
blog icon Recent Articles

Statistics provides valuable information to the optimizer to make decisions on generating optimal explain plan.  The information about the statistics can be obtained by using the “Help Statistics” command however the displayed data cannot be used to join with other tables.  The article provides a java stored procedure and DDL which extracts the output of "Help Statistics" at Table and Column level and capture the data into tables. 

The captured data in the tables helps with:

blog icon Recent Reference

rkolluru hasn't created any reference articles.