Re: Slooooow query question, thanks
Posted in 1995
Todd M. Saylor — — source: Informix-list mailing list archive (1991-1998)
RE: Using <GROUP BY> rather than <DISTINCT> This looks to be the answer I was searching for. I received similar advice from Neil@Storm Software, and I believe it solves the problem. <GROUP BY> is processed quickly, with the same results as <DISTINCT> (in my example, anyway). Thanks for the assistance! -- ------------------------------------------------------------------------------- Todd Saylor | Bi-Tech Software, Inc. "No matter where you go, there you are" | (916) 891-5281 ----------- Opinions expressed are subject to change without notice -----------