Performance of in vs. =

Posted in 1997

Todd Breiholz — Thu, 17 Jul 1997 09:16:48 -0500 — source: Informix-list mailing list archive (1991-1998)

Is there a performancepenalty for using the in clause of a select statement vs. using an =? I would like to set up a generic select and I may have 1 or 2 values to compare to. If I only have one value in an in clause, is it slower than using a straight =? TIA -- ------------------------------------------------------------------- * Todd Breiholz, Webmaster Phone: (515) 248-1714 * * Johnson & Higgins/Kirke-Van Orsdel, Inc. Fax: (515) 248-1777 * * tbreiholz@jh-kvi.com <------------------------------------------- -------------------------->