Logically, your suggestion is good. However, it will require additional
table join. I doubt the efficiency as my table contains more than 10
million of records. Am I too conservative ?
>
> For what purpose? The proper answer in relation to design usually
> depends on understanding the 'natural' relationship between entities
> and the purposes to which data is going to be put.
>
> We have a table with similar layout that is used to track jobs. By
> selecting the data for a jobname in descending date/time order it is
> very easy to see jobs that have started but not finished or terminated
> by error.
>
> IMHO -- Mark D Powell --
Received on Wed Dec 18 2002 - 01:52:58 CST
