On 08/04/2015 19:44, andrew_s_...@yahoo.com [firebird-support] wrote:
After more than a decade of Firebird I'm more than used to using the
+0 to get the results desired from the engine
I'm used to writing compilers, in which world it is inconceivable that a
+ 0 wouldn't get optimised
On Apr 8, 2015, at 10:05 AM, andrew_s_...@yahoo.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Let's see when histograms come to the party, it'll make things more
interesting for sure. G
Histograms may be less useful in Firebird than you might think, unless there's
a
Hi Mark,
Yes, I did a Backup/Restore and updated all the index statistics to give the
engine the best chances possible for the select...
Thanks.
Andrew
Hi Set,
(I assume you have optimized poorly performing queries with Fb 1.5 long ago,
rather than been waiting for the upgrade).
Yes.
If you compare new, unoptimized queries between 1.5 and 2.5, odds are that
you would conclude that 2.5 are better.
I have very high expectations for that.
Hello Ann,
Firebird 1.5 considered the index a good candidate, even if you only matched
the first part. In later, smarter versions, it recognizes that the first part
alone is not very good.
I did change the index to only the boolean 1/0 field... then I changed back
adding a part of the