Mike Matrigali created DERBY-6874:
-------------------------------------
Summary: add table size information to optimizer plan information
printed
Key: DERBY-6874
URL: https://issues.apache.org/jira/browse/DERBY-6874
Project: Derby
Issue Type: Improvement
Components: SQL
Reporter: Mike Matrigali
Priority: Minor
add table size and total row count information available at optimizer compile
time. These can help when looking at why optimizer picked a particular plan
with those estimates at that time.
may need to widen the interface to store to get page counts used by store. For
a cleaner interface maybe just provide an interface for store to include
whatever it thinks is useful to print. That way in case there different stores
or remote VTI's providing stats we are not tied to one set of info. #pages
might not make sense for remote VTI's.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
