Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can this be optimized further?
try
===
create table SP_spr_sp0140767 as
select i.id
,spr.espdate
,spr.promotability
,spr.potential
,spr.evaluator
,spr.evalcomments
,spr.sme
,spr.smeexpertise
from esp_individ_d i
, esp_sprating_d spr
where i.id = spr.id (+)
and nvl(spr.espdate,'x') = (select nvl(max(espdate),'x')
from esp_sprating_d r where i.id=r.id )
Received on Thu Sep 06 2001 - 06:42:14 CDT