| Subject | RE: [firebird-support] Query tuning help... index with only a few values does wonders... Why? |
|---|---|
| Author | Leyne, Sean |
| Post date | 2003-11-25T23:37:10Z |
Colin,
What engine version # are you using?
What is the selectivity of the BigTable.Status index?
How many rows would have meet the BigTable.Status < 8 criteria?
Sean
> I have been trying to speed up a query from 10's of minutes intoA couple of questions...
> something more usable.
What engine version # are you using?
What is the selectivity of the BigTable.Status index?
How many rows would have meet the BigTable.Status < 8 criteria?
Sean