Re: puzzling problem with query

---- you wrote: > Obnoxio The Clown wrote: > > > Unless my math is shot, the count isn't the problem, performance is. UPDATE > > STATISTICS? > > Correct, performance is the problem. I have updated statistics to no avail. I > think I have a real problem on my hands. :( But what indexes is it using Dude? If you have an index on col3, then it is going to be very slow to pull out the Y's. If it does a seq scan, then it will also be slow. You need an index on all three columns to be effective. Also, have you done update statistics high(col3)? AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com