Joshua D. Drake wrote:
> On Mon, 26 Nov 2007 10:28:03 -0800 (PST)
> Richard Broersma Jr <rabroersma@xxxxxxxxx> wrote:
>> --- On Mon, 11/26/07, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
>>> In "theory" the item that would be a natural key
>>> in this instance is the VIN.
And you then need to deal with cars that have mismatched
Body VIN numbers and Engine VIN numbers? It's not uncommon
on older cars or crash damaged cars.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
