Subject Re: [ib-support] Indices and low selectivity
Author Christian G├╝tter
Hi Martijn,

> This column will only have values "N" and "Y" - resulting in
> very poor selectivity... I wouldn't index that column.

OK.
If others have objections, please tell me ;-)

> btw, perhaps - in order to avoid changing all queries, you can
> rename the table (creating a new one, changing FKs etc) and
> create a view with the same name as the table, but has a
> WHERE IsDeleted = 'N' clause appended.

This is a good idea, but a Firebird bug (bad plan when joining
a table and a view) prevents me from doing this.

AFAIK, this bug is fixed in FB 1.5, but I will rather wait until
FB 1.5 is stable before I use it in production.


Thanks,

Christian