Re: dblink: functions enforce tablescan

> select * from a_at_dblink where b=
> (select f from dual);

...alas that does't improve the plan: ora734 decides to make a full scan of dual which is ok but also a 'remote*' and filters locally...

it looks as if ora treats the function like a correlated subquery when it comes to databaselinks... running the same stuff locally evaluates the function first and then restricts the select.

creating the function on the remote side won't work as we would the face the same situation vice versa. (our actual requirements don't allow us to pragma restrict reference rnds and rnps, we just tried that to get a clue what's up).

any ideas?

ciao, jan

http://www.rsp.de/

rs&p-Dossier: Software zur Erstellung technischer Dokumentationen

              und Schriftgutes in Verwaltung und Industrie. Received on Thu Apr 20 2000 - 00:00:00 CDT