|Subject||Re: [ib-support] Indices and low selectivity|
> Hi,Why not copy deleted records to a second "deleted" table and then remove
> 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'.
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.
"Never trust a computer you can't throw out a window."