Mark Collette wrote:
Now, I've added the infrequentId columns to both, as an optimization, so
that I can quickly find the InfrequentTable entry for a given
FrequentTable entry. I've done this because I want to speed up
SELECTs. Any new INSERTs are working just fine. But, all my legacy
entrie
I have two tables, with a many to one relationship.
Table InfrequentTable
- timestamp ts
- int infrequentId (newly added key)
Table FrequentTable(Many FrequentTable entries per one
InfrequentTable entry)
- timestamp ts
- int infrequentId (newly added column)
The
