Re: dblink: functions enforce tablescan

>Check your explain plan again. In particular, examine the OTHER column
>of the PLAN_TABLE. In this column, you'll see the SQL statement that is

select b from a. no restrictions used

>But this does not mean that an index was never used.

i don't understand why the optimizer treats the function as a correlated subquery when databaselinks are involved

limiting the semantics of pragma restrict ... to the local instance and making no assumptions about remote instances would explain this. but then databaselinks would be completely unusable when used in conjunction with functions.

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