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 16:46:22 +0100 Organization: C.R.P.A. S.p.A. (All standard disclaimers applied) Lines: 26 Message-ID: <3C177BCE.854F9E63@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> <3C172BD9.547FF1C2@crpa.it> <9v7n2s022d8@drn.newsguy.com> <3C1770C3.91534E05@crpa.it> 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 1008171972 26221 212.22.134.33 (12 Dec 2001 15:46:12 GMT) X-Complaints-To: news@nettuno.it NNTP-Posting-Date: 12 Dec 2001 15:46:12 GMT X-Mailer: Mozilla 4.7 [en] (Win95; I) X-Accept-Language: en,pl,ja Xref: easynews comp.databases.oracle.server:127959 X-Received-Date: Wed, 12 Dec 2001 08:46:14 MST (news.easynews.com) Mark Townsend wrote: > 1) What happens if you say > where UPPER(ACQUIRENTE_RAG_SOC) like upper('VERO%'); Nothing changes. = > 2) How many rows in the table and what % of the rows qualify the condit= ion ? > - it's entirely possible that the FTS is faster than the index lookup 5/10904 =3D 0.05%. But perhaps what you say it's true. The query is indee= d very fast! 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)