Re: how to optimize this query

2005-05-27 Thread SGreen
Kevin Weslowski <[EMAIL PROTECTED]> wrote on 05/26/2005 02:20:46 AM: > Hi, > > I've got a query that I believe should be giving me better performance > than it is, since I've put indexes on all the appropriate columns...I'll > include as much info as I can for anyone wishing to help me optimiz

Re: how to optimize this query

2005-05-27 Thread Kevin Weslowski
Well, it seems you've helped solve my problem, Shawn...here we go: first off, sorry about the text wrapping and the sloppy sql...I do get lazy sometimes...I am a programmer :P you asked how fast this runs: SELECT ind_first_name , ind_last_name , fam_phone , max(iat_dat