Re: Optimizer

Posted in 1999

Obnoxio The Clown — Fri, 14 May 1999 06:34:56 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Gaetano Mendola'" <mendola@bigfoot.com> > >Optimizer use the information Primary-Key <----> Foreign-Key >for optimizing joins? >With only index on this columns, I obtain same result ? Pretty much. Informix implements primary and foreign keys via indexes. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com