Subject Re: [firebird-support] FB 2.0 optimizer dogging us
Author Arno Brinkman

>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.

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!