Path: news.easynews.com!easynews!feedme.news.mediaways.net!newsfeed.nettuno.it!not-for-mail From: Cristian Veronesi Newsgroups: comp.databases.oracle.server Subject: Re: how to use function-based indexes? Date: Wed, 12 Dec 2001 11:05:13 +0100 Organization: C.R.P.A. S.p.A. (All standard disclaimers applied) Lines: 50 Message-ID: <3C172BD9.547FF1C2@crpa.it> References: <3C161340.D3125449@crpa.it> <3C161C88.D90F4A75@crpa.it> <3c162283$0$230$ed9e5944@reading.news.pipex.net> <3C162538.F77972CB@crpa.it> <3c165eb1$0$561$afc38c87@news.optusnet.com.au> <9v6a6r02drd@drn.newsguy.com> <3C17174E.922A7642@crpa.it> <3c17230b$0$8512$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: eraclito.crpa.it Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: pinco.nettuno.it 1008151506 19963 212.22.134.33 (12 Dec 2001 10:05:06 GMT) X-Complaints-To: news@nettuno.it NNTP-Posting-Date: 12 Dec 2001 10:05:06 GMT X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en,pl,ja Xref: easynews comp.databases.oracle.server:127927 X-Received-Date: Wed, 12 Dec 2001 03:05:09 MST (news.easynews.com) Niall Litchfield wrote: > how many rows does your query return? 5 rows from 10904 > how many blocks in the table? 64 > have you analyzed the table (sorry can't find if you've posted this inf= o or > not). Yes, I did: SQL> analyze table acquirenti compute statistics ; Table analyzed. > if this is performance critical - I read your posts as just investigati= on - > you could of course hint the statement. I tried, with the same result: SQL> explain plan for 2 select * from acquirenti /*+ INDEX(acquirenti xie1acquirenti) */ 3 where UPPER(ACQUIRENTE_RAG_SOC) like 'VERO%'; Explained. SQL> select * from plan_view ; OPERATION OPTIONS OBJECT_NAME POSITION -------------------- -------------------- -------------------- -------- SELECT STATEMENT 10 TABLE ACCESS FULL ACQUIRENTI 1 Thanks for your help. Best regards, Cristian -- = Cristian Veronesi ><((((=BA> http://www.crpa.it There are no good wars, with the following exceptions: The American = Revolution, World War II, and the Star Wars Trilogy. (Bart Simpson)