Re: Question about search performance
Re: Question about search performance
- Subject: Re: Question about search performance
- From: Petite Abeille <email@hidden>
- Date: Wed, 17 Sep 2008 22:59:26 +0200
On Sep 16, 2008, at 7:35 PM, Joshua Dubey wrote:
SELECT <bunch of attributes>, from ORDERS T0 WHERE
UPPER(T0.EMAIL_ADDRESS) LIKE UPPER('email@hidden%') ESCAPE '\;
In general... 'like' predicates are tricky to optimize from a SQL
engine point of view...
In Oracle... for simple case insensitive search you could consider
function based indices... for general text search, take a look at
Oracle Text ctxsys.context indices or such...
One way or another, dbms_stat is your friend.
In case of doubt, consult dbms_xplan.
Cheers,
--
PA.
http://alt.textdrive.com/nanoki/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden