Best way to effective date??

We are having a major debate over the best way to do effective dating. If we just use <entity><effective date><effective dated info> it seems that the sql to get at these dates is really wierd. It would have to involve major sorting (unless the field was indexed which can pretty much be assumed). So to get the effective data for a date would require something like:

SELECT max(effective_date)

   FROM mytable
  where entity_id = :entity_id_var and

        effective_date <= :date_to_get_effective_data_for;

This seems awfull ineffecient. Anybody got any better ideas???

  Thanks,

Chad A. Brockman
chadb_at_NeoSoft.com
VertiComp, Inc. Received on Wed Apr 20 1994 - 02:31:09 CEST