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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based indexes and index fast full scan

Re: Function based indexes and index fast full scan

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 2 Jul 2002 16:36:42 +0400
Message-ID: <afs6p2$pn4$1@babylon.agtel.net>


"Per-Arne Hellarvik" <phellarv_at_genuity.no> wrote in message news:afre36$c00$1_at_news1.c.no1.asap-asp.net...
> As I remember when doing SQL-tuning :
> Functions on indexed columns is bad for the indexes.

...unless indexes are built on these functions (function-based indexes), and the question is about such indexes.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Jul 02 2002 - 07:36:42 CDT

Original text of this message

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