Subject Re: [Firebird-Architect] Index structures
Author Jim Starkey
At 03:12 AM 5/25/2003 +0200, Arno Brinkman wrote:

>I have done a query on a table with 1 million rows which joins another table
>with 1 million rows. Pagesize = 8192, PK's are INTEGER, buffers = 10000,
>Win2K, FB1.5-SS. The join criteria contains a equal comparision so that for
>every record on table1 a index-lookup is done on table2 (which returns 1
>record, PLAN JOIN(T1 NATURAL, T2 INDEX (PK_TABLE2)) ). These are the results
>of Quantify :

The screen shot is a little hard to read, but it's exactly what I would
expect. I
don't see BTR compress there at all. Did I miss something?

Jim Starkey