Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Case insensitive index scan

Re: Case insensitive index scan

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Fri, 14 May 1999 14:19:56 -0400
Message-ID: <7hhqkj$bkf$1@autumn.news.rcn.net>


Modify the queries so that they convert the name to the format used in the index.

regards

Jerry Gitomer



ebektech wrote in message ...
>I have a simple table which contains around 50,000 rows, defined as:
>
>CREATE TABLE CUSTOMER(NAME VARCHAR2(35));
>
>with an index on the name column defined as:
>CREATE INDEX AIX_CUSTOMER_NAME
>ON CUSTOMER(NAME);
>
>The customer names are stored with upper and lower case characters ie.
>Smith. or O'Grady. The users querying this table want to be able to search
>customer names
>without having to specify the exact case for each of the characters in the
>name.
>ie. select * from customer where upper(name) = upper('SmiTH');
>
>Oracle will does a full scan of the customer table for the above statement
>and
>the response time is not acceptable. Is there any other way other then
>adding another column to the table to force Oracle to use the index?
Please
>reply to newsgroup and my mail address.
>
>Thanks
>
>
Received on Fri May 14 1999 - 13:19:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US