dblink: functions enforce tablescan

hi,

how can we prevent the oracle optimizer from making complete tablescans when using data-base-links?

create table a (b number primary key);
create function f return number as begin return 42; end; select * from a_at_dblink where b=f;

the plans differ whether one uses a local or a remote-table..

we originally use packaged functions but even pragma restrict reference(f,rnds,rnps,wnds,wnps) does not help.

any ideas why this happens and what we could do?

ciao, jan

http://www.rsp.de/

rs&p-Dossier: Software zur Erstellung technischer Dokumentationen

              und Schriftgutes in Verwaltung und Industrie. Received on Wed Apr 19 2000 - 00:00:00 CDT