Hi,

>> A couple of questions...
>> What engine version # are you using?

Have been testing it on 1.5 RC 6

>> What is the selectivity of the BigTable.Status index?

By selectivity, do you the number of different items or the index
statistics? The status value has 9 values, most of them would be either
8 or 9. Only the 'current' ones are less than 8. The index information
is as follows:

Statistics: 0.100000001490116119

Index BigTable_IDX2 (6)
Depth: 3, leaf buckets: 2406, nodes: 3264049
Average data length: 0.00, total dup: 3264039, max dup: 3166674
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2405

Not sure what all that means, or where to find out what that all
means...

>> How many rows would have meet the BigTable.Status < 8 criteria?

8 is the status that things finish on... So the percentage < 8 would be
relatively low... For the example given the total rows in the table was
3,264,049. This table is the main information store for the system and
is likely to grow quite substantially. The number of rows returned from
the query was about 23,000. This is also likely to grow but should
stabilise at around 100,000 at a guess.

Regards
Colin

Ps. Sorry for delay in replying with info, have been out of the office
for a bit.

-----Original Message-----
From: Leyne, Sean [mailto:sleyne@...]
Sent: Wednesday, 26 November 2003 12:37 p.m.
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Query tuning help... index with only a
few values does wonders... Why?



######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################