It doesn't get any simpler than this. :)
The Select statement takes way too long to complete.
select rcd_id, company_name from company where company_name like fra%
12357 rows fetched (86.08 seconds)
However if it returns just the column value from the index, it is quite fast:
select company_name
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
[mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 2:40 PM
To: [EMAIL PROTECTED]
Subject: Poor Select speed on simple 1 table query
It doesn't get any simpler than this. :)
The Select statement takes way too long to complete.
select rcd_id, company_name from company where
-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 table query
It doesn't get any simpler than this. :)
The Select statement takes way too long to complete