Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle function based index not being utilized
How many records in consumer?
hhjin_at_yahoo.com (Helen) wrote:
>We are running on Oracle EE 8.1.7.3 on Sun Solaris 5.8.
>We use cost based optimizer.
>
>I have created a function based index as of following,
>
>create index IDX_CONSUMER_LOWER_FIRSTNAME
>on consumer(lower(first_name));
>
>Then I need to run the following query, it suppose to utilize
>the index I have created, but it did not.
>
>select consumer.id from consumer
>where lower(first_name) = 'serpie';
>
>
>This query still does a full table scan,
>
>Query Plan
>-------------------------------------------
>SELECT STATEMENT Cost = 7465
>TABLE ACCESS FULL CONSUMER 1
>
>Any input?
>
>Thanks
>
>Helen
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Aug 02 2002 - 14:54:42 CDT