4GL Query Optimizer Base Line

4GL Query Optimizer Base Line.

If a company wants to back this project I believe we can have a running version within 2 to 3 month.

It is up to us to build one.

Tool to report index selection analysis for a query

This tool allows you to enter a query on a table, and reports detailed index selection information for you, including an index tree (of one or more indexes) that the compiler would construct for this query, plus an analysis of indexes for each node of the index tree to help explain why each index was chosen.

The source code for this tool (written in Progress 4GL/ABL V9.1) is included in the download. It is quite heavily commented to help explain all the compiler's index selection behaviour (including how/why multiple indexes are sometimes selected). The UI is very simple so it can be used i

Syndicate content