Re: 7.30UC2 - Subquery uses Autodindex instead of Index

Posted in 1999

Obnoxio The Clown — Sat, 29 May 1999 21:56:22 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Art S. Kagel wrote: > >.. . . lotsa good things snipped . . . > > > language NOT a programming language. If you phrase the query in > > English like a programmer you will ALWAYS come up with a correlated sub > > query (I've seen it hundreds of times) but if you phrase the query in > > English like a USER would tell it to you the you will ALWAYS come up > > with a join instead. TRUTH! This is Kagel's Second Law of SQL. > > > >OK, I'll bite . . . what's Kagel's First Law of SQL? There's always 3 ways to write a SELECT statement? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com