Requires Free Membership to View
The optimizer is missing statistics that it needs in order to make informed decisions. The DBMS_STATS package can be used to calculate statistics on these objects. There are many options with the DBMS_STATS package, so I would suggest looking at the Oracle documentation to determine how to best use this supplied package:
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_stats.htm#996915
This was first published in October 2004

Join the conversationComment
Share
Comments
Results
Contribute to the conversation