performance for low selectivity indices (QC#1035)


2005-09-09 04:57:29 PM
delphi52
Hello,
more than 2 years ago there was a topic in this newsgroup
concerning the performance problems of interbase when selecting
using an index with low selectivity. The discussion led to the
creation of QC report 1035.
Is there any chance that someone will take care of this point
in the near future?
The background is that we are thinking about to change the dbms of
our major clients form Firebird to Interbase due to the SMP support
that offers Interbase. When starting to make some tests we ran into
the problem discribed in the above mentioned report. The reason is
that we are making exhaustive use of foreign keys in order to
automatically show lookup-values in the dialogs of our application.
Stefan