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 simple 1
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
You could always add an index on company_name + rcd_id. That technically
shouldn't help, but I've seen crazier things before.
Donny
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 4:23 PM
To: [EMAIL PROTECTED]
Subject: RE: Poor Select speed