Re: Remote cursors (cursors across DB links)

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 30 May 2001 16:40:07 +0200
Message-ID: <SD7R6.3098$lM3.72606@news1.oke.nextra.no>

Hi!

Also have a look at using inline views/stored views in the from clause. If you are able to modularize the part of the query (the tables) that are remote, in a inline view (or stored view) the optimizer may find it possible to send the inline view to the remote database for prosessing.

eg.
SELECT col1, col2, col3,

FROM local_table_1 ,

            local_table_2 ,
           (SELECT *
            FROM remote_table_1, remote_table_2
            WHERE join remote tables
            AND get rid of useless rows from remote database)

WHERE more AI

Frank Received on Wed May 30 2001 - 09:40:07 CDT