02.03.2016 14:09, Atri Sharma wrote: > That's fine, I am fine with anything in the planner, or maybe > transactions ...
Then the start would be not from the planner, but from the statistics collector ;-) Take a look at the GSTAT utility, located under /src/utilities/gstat/, the code is mostly limited to dba.epp. It scans the database and reports various statistics. The first step could be extending this tool to collect and report (optionally?) value distribution histograms for table columns (all? indexed? explicitly specified?). At the same time, you would need to create memory structures to describe histograms. How many buckets? How to store very-selective and non-selective distributions? Etc. Dmitry ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel