For large datasets with 32bit guid keys there can be a performance boost using the .null. in the sub-select. I've not seen a dramatic increase otherwise.
The second command threw the error, and would expect odd things like that. Tracy -----Original Message----- From: Paul McNett Sent: Wednesday, September 26, 2007 5:37 PM Tracy Pearson wrote: > I simplified version went something like this: > > Select * from t1 where exist (select .null. from t2 where t2.key = > t1.key) How is this different from: select * from t1 where exist (select t2.key from t2 where t2.key = t1.key) BTW, the selecting of .null. intrigued me so I tried it in VFP8. Check out the funky result: http://paulmcnett.com/vfp/vfp8_null.png ;) -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] 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/[EMAIL PROTECTED] ** 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.
