Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!news.indigo.ie!not-for-mail Reply-To: "Telemachus" From: "Telemachus" Newsgroups: comp.databases.oracle.server References: <15c7b652.0303021747.2177140d@posting.google.com> Subject: Re: index on upper case Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Mon, 3 Mar 2003 10:45:39 -0000 NNTP-Posting-Host: 62.77.170.89 X-Complaints-To: abuse@eircom.net X-Trace: news.indigo.ie 1046688339 62.77.170.89 (Mon, 03 Mar 2003 10:45:39 GMT) NNTP-Posting-Date: Mon, 03 Mar 2003 10:45:39 GMT Organization: Eircom.Net http://www.eircom.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:178242 X-Received-Date: Mon, 03 Mar 2003 03:45:33 MST (news.easynews.com) OH LORDY ... I'M STUCK FOR WORDS.... "Keith Langer" wrote in message news:15c7b652.0303021747.2177140d@posting.google.com... > I am trying to create a case insensitive index. > > Below is a test index: > > CREATE INDEX IDX_PERSON_FIRST > ON PERSON(UPPER(FIRSTNAME)); > > > When I run it from my local user (schema owner) account, I get a > permission problem. When I run it from the System account, it gets > created. But then when I run EXPLAIN PLAN on the following query: > > select * from person where UPPER(FIRSTNAME) = 'MIKE'; > > I still get full table scans. > > So what's going on here? > > Keith