Svein, the selectivity of source_id is 0.000446 and commit_number is 0.01.
So, it is not clear
why FB is not using index on commit_number to filter AND sort on.
I'd agree, Alec, if your where clause had involved
PHYSICAL_COPY.COMMIT_NUMBER = 1000, but = and = are two very different
Tom Munro Glass schrieb am 05.06.2012 um 16:42 (+1200):
The CentOS package firebird-2.1.4.18393.0-1.el5 installs firebird.conf
in /etc/firebird/firebird.conf and /var/lib/firebird/firebird.conf.
Shouldn't one of these be a symlink to the other
I'd say the one in /etc is meant to be used for
Firebird doesn't have histograms yet, and logically speaking (I do not
know the internals of the optimizer, nor the selectivity of your
indexes, so this is how I would think if I should do things manually):
Just as an aside, histograms will be less of a gain for Firebird than for
some
Dear FireBird support
Excuse me for my ignorance, but I hope you can help me. I don't know if my
simple issue is qualified for this support group, but anyway I hope to get some
suggestions.
I have run a FireBird server for many years. I am currently using the version
installed via the package
magnusanger schrieb am 05.06.2012 um 06:22 (-):
I have run a FireBird server for many years. I am currently using the
version installed via the package Firebird-2.1.1.17910-0_Win32.exe.
I now plan to swap to a Windows 2008 64-bit server, and of course need
to install another version of
Michael Ludwig schrieb am 05.06.2012 um 09:52 (+0200):
http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-compat
http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-engine-stats64
That applies only if you intend to upgrade to 2.5, of course. Which is
what I had read into your
W O wrote:
Never use double precision for money neither for count something, use it
for measures.
Actually, you can use it to _count_ as long as all individual items are
integers. Double precision is built that way to keep integer arithmetics
clean as long as all operands are integers and
I am assuming you meant to use LEFT not INNER JOIN, right?
Right - and right that I got SAP and SAS confused (again). Typing,
talking, and trying to get the dog to stop emptying the trash should not be
done simultaneously.
Ann
[Non-text portions of this message have been removed]