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:[EMAIL PROTECTED] * 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
