11.04.2016 14:08, Molnár Attila wrote: > >> When InterBase was created, there was a lot of academic work on >> optimizing corner cases, with the result that academic databases >> tended to spend more time optimizing than retrieving. We made the >> deliberate choice not to spend optimizer time saving idiots from >> themselves. Thirty years later, maybe we'd choose differently. >> However, lots of programs depend on tricks like +0 and concatenating >> with an empty string to coerce unnatural but effective plans. I'd >> worry about the damage done to those cases. > > This optimization can only be done if constant conditions are in the > SQL, so +0 like tricks would not be affected.
I already considered that, it seems easy enough to implement. Dmitry ------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/ gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
