RE: Poor Select speed on simple 1 table query

2004-11-15 Thread Donny Simonton
Subject: RE: Poor Select speed on simple 1 table query > > At 03:32 PM 11/15/2004, Donny Simonton wrote: > >Mos, > >Personally, I never use like for anything. I would add a fulltext index > >myself and call it a day. But that's me. > > > >Donny > >

RE: Poor Select speed on simple 1 table query

2004-11-15 Thread mos
At 03:32 PM 11/15/2004, Donny Simonton wrote: Mos, Personally, I never use like for anything. I would add a fulltext index myself and call it a day. But that's me. Donny Donny, Unfortunately I can't. The query must return all rows that *start* with a certain phrase. It's similar to doin

RE: Poor Select speed on simple 1 table query

2004-11-15 Thread Donny Simonton
Mos, Personally, I never use like for anything. I would add a fulltext index myself and call it a day. But that's me. Donny > -Original Message- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 2:40 PM > To: [EMAIL PROTECTED] > Subject: Poor Select speed on simpl