Re: Oracle Text index question, somewhat urgent

On Thu, 13 Jun 2002 01:08:29 -0800, Conner wrote:

>I don't have Text installed on a db thats readily to
>hand, but isn't this just a case of running the
>following and seeing what happens:

<snip>

Well yes I could have tested it, but I don't have Text installed either, and even if I did have it installed I don't know how to use it. And I was working very late against a deadline. I was handed that information about case-insensitive indexes by a Product Manager at Oracle to use as a brief note in a book. (The book is not about Oracle Text, by the way) I just wanted some independent verification that what Oracle told me was, in fact, correct.

By the way, I appreciate all the responses, especially Bill's pointer to the correct spot in the documentation.

If you're interested in how this whole issue came up, I was writing a section on Oracle9i's support for SQL semantics for LOBs for a book. For example, you can now apply the UPPER function to a CLOB column. While it seems reasonable to want to write a case-insensitive query, performance would likely be horrible if you unleashed a query that applied UPPER to some truly large CLOBs, especially if the result was a full table scan, as it likely would in the example I used. In that case, I'm suggesting that readers take a look at using Oracle Text.

Jonathan Gennick --- Brighten the corner where you are mailto:jonathan_at_gennick.com * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: listmail_at_gennick.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).