thanks!
it would probably have to be some sort of java bolt on ? i don't know about that
i also though about reaching into the sql stats but afaik they're not avail to the 4gl thru vsts or any other way.TomBascom said:I'd like to see the cost based optimizer used by the 4gl too. But I'm not holding my breath. It is, by all accounts, a big leap -- not for the database engine but for the 4gl. I haven't tried this but I've long thought it would be interesting to take the cost statistics that are gathered for SQL and apply them to selectively over-ride 4gl index selection. If I ever run into one of those horrible queries that you seem to so commonly find I plan to give it a whirl.
it would probably have to be some sort of java bolt on ? i don't know about that