Aldo Caruso wrote:

> your approach is correct provided the fact that in your case you
> criteria to define a record as historic is only its timestamp ( be it
> limited to the current day or any other date time criteria ).
>
> Unfortunately that is not my case: records contain real estate data
> and they become historic when properties are sold or the bid is
> withdrawn, a manual criteria which is reflected by a boolean flag in a
> field (or by moving the record into another table)

The point is still valid. An index which combines your 'state' flag with a
timestamp provides a filter so you can look for 'all withdrawn bids between ...'
for example, and the like. I have caller, telephone, emails, correspondence and
the like for each day which can then be filtered in a similar way. Moving
records between tables is a little pointless if they form a part of a bigger
'query' such as 'all activity in March' ?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk