Hi,

I like to get some more information from the engine about the execution path choosen.
The information were i'm talking about, are the estimation numbers calculated by the optimizer such as Cardinality, Selectivity, Cost.
Recently i added an information item (isc_info_sql_get_raw_plan) to get the the raw (isc_info_xxx items) data from the execution path on the client, because the PLAN text information doesn't show all information.

Now is my proposal to extend these information items with isc_info_rsb_estimation and under this item the items for cardinality, selectivity and cost.
If nobody has objects i'll add this functionality to Vulcan.
The next question is how to represent a double (which data structure) in those information items.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database developer support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features:
http://www.firebirdsql.org
http://www.firebirdsql.info

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info


[Non-text portions of this message have been removed]