Subject RE: [firebird-support] FB 2.0 optimizer dogging us
Author Rick Debay
> At time the PK constraint (and his index) is created there was no data
inside the tables.
OK, that makes sense. Too bad the engine can't do this on its own. But
I guess since it has to be done just once, the burden should really be
on the DBA.

-----Original Message-----
[] On Behalf Of Arno Brinkman
Sent: Friday, December 01, 2006 11:34 AM
Subject: Re: [firebird-support] FB 2.0 optimizer dogging us


>I think you solved it, now FB2 is coming up with good plans. Now the
>question is, why do all my primary key indices have no statistics
>computed for them?

Because you first created all metadata and imported the data after that.
I Assume you first created the tables with only the PK's, then filled
with data, then created foreign-keys / indexes.

When an index is created the statistics value is computed, thus when the
foreign-keys/indexes were created there was real data to compute that
At time the PK constraint (and his index) is created there was no data
inside the tables.

Arno Brinkman

General database development support:

Firebird open source database (based on IB-OE) with many SQL-99 features

Support list for Firebird and Interbase users :

Nederlandse firebird nieuwsgroep :

Mijn Postvak In wordt beschermd door SPAMfighter 960 spam-mails zijn er
tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!


Visit and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.