Subject Re: [ib-support] Indices and low selectivity
Author Woody (TMW)
> Hi,
> I have got a small table with about 5.000 records (large
> rows) and approx. three inserts a day. Sometimes records
> from this table have to be deleted and my customer wants
> that these are not physically deleted, but only marked
> as 'deleted'.

Why not copy deleted records to a second "deleted" table and then remove
them from the original. That way, you don't have to worry about changing
your queries at all. If you want to see all records, you could do a UNION on
the two tables. Seems to me to be easier than changing everything else.

Woody (TMW)

"Never trust a computer you can't throw out a window."
-Steve Wozniak