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

Home -> Community -> Usenet -> c.d.o.server -> Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

Re: Horrible Query Performance, Simple Query -- Performance Tuning Help Needed

From: <stevedhoward_at_gmail.com>
Date: 22 Apr 2006 05:54:52 -0700
Message-ID: <1145710492.754087.163510@z34g2000cwc.googlegroups.com> 





What does the tran_clinician() function do?



decode(d.dictating_clinician_name,

              null,
              tran_clinician(d.dictating_clinician_ncid,
                             e.event_id),
              d.dictating_clinician_name) Clinician





BTW, probably no impact, but couldn't you do the same with NVL() rather
than DECODE()?



Regards,



Steve
Received on Sat Apr 22 2006 - 07:54:52 CDT












Original text of this message













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