On Fri, February 20, 2009 12:18 pm, Tracy Pearson wrote: > Only when the indexes are bad. I get the same results with select > statements flattening the data. Until I fix the index, or use NOOPTIMIZE > on the select statement. > > I've seen your behavior due to a problem with other code assigning the > wrong parent key. > > HTH, > > > Tracy
It doesn't help that the one table has no unique primary key. Grrr.... _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/20210.69.7.77.20.1235163342.squir...@webmail.dssco.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.