Query problem

[jmodic]

Originally posted by slimdave
It's a real long shot, but maybe ...
Probably won't work because the hint is really to do with join predicates.

Nope, I've tried to fool it with some of the hints too (like NO_MERGE), but it doesn't work.

Originally posted by slimdave
Here's another desperate attempt.

select * from(select (select DoCalculate(aLongitude,aLATITUDE,a.LONGITUDE,a.LATITUDE) 
from dual) mileage_calcualted
from TABLEx
)
where mileage_calculated is not null

Kudos!

Now that's what I call "master of obscure syntax", but hey, it works! It realy calls function only once per row processed.

Who cares if noone understands what the query is supposed to do, as long as it runs realy fast.