| Subject | Re: [Firebird-general] Three open source databases - some benchmarks |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-03-01T23:26:27Z |
Aage Johansen wrote:
only the primary keys of dim0, dim1, and dim2 are indexed. Given the
indexes available, there's no way to avoid a natural (or sequential
scan) pass on some of the tables. Perhaps the other systems would also
benefit from secondary indexes.
Regards,
Ann
>Firebird would do better with some secondary indexes. In this test,
> All queries used NATURAL - is this typical? Or interesting.
only the primary keys of dim0, dim1, and dim2 are indexed. Given the
indexes available, there's no way to avoid a natural (or sequential
scan) pass on some of the tables. Perhaps the other systems would also
benefit from secondary indexes.
Regards,
Ann