Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based indexes and index fast full scan
"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