By the way, I have heard that SQL's work slower when tables are ordered. Is that true?
>>ASSUMPTIONS
>>1. The table is already sorted on Foreign Key + Data Field
>>2. The values for Data Field are known in advance and are stored in another table, usually not more than
>>100-200 values
>>3. The table can have many millions of records, so creating interim tables by breaking up the SQL into
>>two passes risks the 2G limit.
>>4. For the doubters, yes the table is indexed and the self-join still takes > 24 hours when indexed.
>>
>>Thanks
Christian Isberner
Software Consultant