Hi,

<snip>

> What we got here:
>
> 1. 1K blobs ARE placed on data page, if they fit. Yes, they fit.
> 2. 9K blobs ARE NOT placed on data page since they don't fit
> 3. table statistics shows exactly DATA pages used, not blob pages.
> 4. gstat reports record length excluding blob placed on data page.
> user can question "what is really takes so much data pages if
> my record is so small".
>
> (Interesting point - how will optimizer calculate cardinality
> for a, b, c and d? As I know it looks at table pointer pages,
> so calculated records will be out of reality for tables b and c).

Certainly a interesting point. Calculated cardinality is in fact depending
on if a BLOB needs to be fetched yes or no.
Also does the used record-size for calculating cardinality include average
blob-size, i'm afraid not.
Thus with any BLOB, cardinality could be to far away from reality.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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 Interbase and Firebird users :
firebird-support@yahoogroups.com

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