Hi All,
I've been studying the optimizer of firebird for a while, and I was
wondering how the optimizer chooses join order? As most query optimizers
determine join order via a dynamic programming algorithm pioneered by IBM's
System R database project, does the optimizer of firebird use similar
We are in a testing phase of migrating a client from an As400 database and
application to our Firebird (2.5) based delphi application.
Every night we do the following :
delete most of the data in the firebird database
backup and restore the database using gbak
re-import data from the
select sp.STUDENTSEQ, a.User_ID
from supprog sp
join Advocate a on sp.ADVOCATE_CODE=a.Advocate_Code
where a.USER_ID=37
PLAN JOIN (SP NATURAL, A INDEX (ADVOCATE_)) is slow.
Firebird simply thinks this is the best plan. As you know, it isn't and the
simplest way to tell the optimizer that it
This thread generated a lot of responses and I'd like to thank everyone for
helping me. Several came in after I left work yesterday and I want to
answer those, but it seems the consensus is to use the tweak || ''.
Thomas, thanks for the brief explanation of index statistics. That's helps
me a
Hi Everyone,
I am almost embarrassed to ask, but, I am having a great deal of difficulty
with setting this up.
I have a brand new installation of Ubuntu LTS Server 14.04
I have installed firebird superclassic.
I have used gbak to restore a database without any problems
I can connect to my
How this command does it look
sudo netstat -tap -n | grep firebird
it should look something like
tcp0 0 0.0.0.0:30500.0.0.0:* LISTEN
1566/firebird
also you should check iptables rules
sudo iptables -L
Hello.
At http://www.firebirdsql.org/en/downloads the available release of
Firebird to download is 2.5.2.
Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist,
where can I download it?
--
Atenciosamente,
Hugo Eyng
At http://www.firebirdsql.org/en/downloads the available release of
Firebird to download is 2.5.2.
2.5.2 Update 1 is the latest official/production-ready release.
Somebody mentioned a 2.5.3 release. Is there a 2.5.3 release? I exist,
where can I download it?
Only as a snapshot build.
On Tue, May 13, 2014 at 10:37 PM, Zhan Li zhanl...@gmail.com[firebird-support]
firebird-support@yahoogroups.com wrote:
Hi All,
I've been studying the optimizer of firebird for a while, and I was
wondering how the optimizer chooses join order? As most query optimizers
determine join order