Re: Any suggestions on how to improve this SELECT query?

Hi. On Fri, Nov 16, 2001 at 01:58:54PM -0700, [EMAIL PROTECTED] wrote: > > Hi there, > > I'm wondering if someone can help me figure out how the following SELECT can > be improved. > > SELECT count(*) > FROM mm_ind_intrst mm0 STRAIGHT_JOIN ind > STRAIGHT_JOIN mm_ind_

Any suggestions on how to improve this SELECT query?

Hi there, I'm wondering if someone can help me figure out how the following SELECT can be improved. SELECT count(*) FROM mm_ind_intrst mm0 STRAIGHT_JOIN ind STRAIGHT_JOIN mm_ind_intrst mm1 WHERE ind.cust=8 AND ind.mail_list=1 AND ( (mm0.intrst='148' AND mm