> >>It is a Very Bad Idea to involve dates in keys, too.
>>not my idea.
>>The world out there requires that.

> No, the world out there doesn't require you to involve dates in keys. The

world out there requires movement numbers to be unique within year.

For ex, is there a faster way than using a date index for finding the number
of patients and number of tests that are being studied for every month in
the year before? Should I get the rec.no of the first and get the rec.no
of the last patient for an interval first and use rec.no as an index instead
of a Datetime field? I tried that, but using a numeric index didn't increase
the performance that I could notice.