On 5/17/05, Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> From: "Rod Heyd"
> > Tables Version_(1-5)
> >
> > --
>
> > ID |PRODUCT_ID |DATA1 |DATA2 |DATA3 |.|DATA_N |
> > -
You should have a compound index in all your tables on ID+PRODUCT_ID,
since that is what you are joining on. Ideally, you should also have an
index on the DATA column that you will be using in the WHERE clause.
But your structure does really lend itself to this.
Going forward, you may think
From: "Rod Heyd"
> Tables Version_(1-5)
>
> --
> ID |PRODUCT_ID |DATA1 |DATA2 |DATA3 |.|DATA_N |
> --
I have a question about joins. My situation is as follows:
I have 5 tables identical in structure. Each table represents essentially
the same data, however, the data in each table represents a different
"version." The processing involved in generating the values stored in each
table may have ch
