When your are binding the program
will u give an option EXPLAIN(YES)
then thie will populate the values into the plan table.
normally plantable will will be named as
PLAN_TABLE with ur qualified object owner
following checklist to see that you have not overlooked some of the basics:
?Is the query coded as simply as possible??
?Are all predicates coded correctly??
?Are there subqueries in your query??
?Does your query involve aggregate functions??
?Do you have an input variable in the predicate of an SQL query??
?Do you have a problem with column correlation??
?Can your query be written to use a noncolumn expression??
Post the query.........Somebody can help you........
Or contact your DBA's