> 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-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Arno Brinkman
Sent: Friday, December 01, 2006 11:34 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB 2.0 optimizer dogging us

Hi,

>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
value.
At time the PK constraint (and his index) is created there was no data
inside the tables.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features
:
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info

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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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.