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 PROTECTED]') 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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
