Hi Arno,

>> CASE 4: (Quoted above, three table left joins with a where clause on
>> date column)
>> Result:
>> PLAN SORT (JOIN (JOIN (P NATURAL,O INDEX (FK_ORDERDET_REFERENCE_ITEMS)),
>> M INDEX (PK_ORDERMASTER)))
>> First run : ~60 seconds (1.0.796 = ~60 seconds)
>> Subsequent Runs : ~51 seconds (1.0.796 = ~60 seconds)

> Is Product.ProductID unique ?

Looking at sugi's tables creation script (you can find it in the first
message dated March 1st), Product.ProductID is a primary key. Also, in
that message you'll find stats on how many records are in the
different tables.

If you can't find the message, just let me or sugi know.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)