Re: SQL Question

the easiest would be to have a function based index on the column.

joe
> Steve Haas wrote:
>
> Good morning,
>
> Env't: Oracle 8.1.5, HP-UX 11.0 (64 bit)
>
> Given the following tables:
> emp with 100 rows
> dept with 10 rows
>
> and this SQL:
> select emp.ename, initcap(dept.deptname)
> from emp.dept
> where emp.deptno = emp.deptno;
>
> The questions -
> How many times is the initcap(dept.deptname) function actually
> "executed"?
> Is it once for each emp row (100 times) or once for each dept row (10
> times) or some other value?
>
> Another scenario -
> Would it be faster to retrieve rows with a bunch of similar functions
> (initcap, concatenations of columns and/or literals, etc) or to have
> and maintain the data in columns with the data formatted as such?
>
> TIA gurus...
>
> Steve Haas
> Opus Consultants, LLC

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).