query running realy slow 1

[blexman]

Can anybody help me speed up this query ? I have an index on
p.pptyno and pn.pptyno. Is there anyway of recoding the date logic in the where clause ?

select
count(*)
from
pn,
p
where p.pptyno=pn.pptyno and
pn.filedate>=decode(p.saledate,0,p.adjdate,p.saledate)



thanks

 

[karluk]

I think the following is an equivalent expression that avoids function calls. With luck the performance will be better.

select
count(*)
from
pn,
p
where p.pptyno=pn.pptyno and
(p.saledate = 0 and pn.filedate >= p.adjdate
or
p.saledate <> 0 and pn.filedate >= p.saledate)

 

[blexman]

Yes ..perfect..thanks!

hani