Re: dblink

Hi!(very sorry if this becomes duplicated now, but strange things happen with my Outlook Express :-)

I have not tried it myself, but I believe that in Oracle 8/8i you should try inline views/DRIVING SITE hints/views on remote site. Oracle might be able to do something useful with a query like:

SELECT stuff, stuff
FROM (SELECT ...........

            FROM a_remote_table_1_at_a_remote_site_A
            WHERE ....get rid of absolutely useless rows from remote
database )  alias_remote_info_1,
            (SELECT ............
            FROM a_remote_table_2_at_a_remote_site_B,
                        a_remote_table_3_at_a_remote_site_B
            WHERE join remote tables
            AND ....get rid of absolutely useless rows from remote
database )  alias_remote_info_2
            local_table

Oracle might find it possible to send the inline views over to the remote database for processing (if it
manages to use indexes Im not sure), and you could possibly get rid of a lot of useless rows. Then Oracle
just send useful row (or "perhaps" useful rows).

Also creating views on the remote database instead of the inline views are possible.

Frank

íÉÈÁÉÌ îÏÓÏ× <M.Nosov_at_vaz.ru> wrote in message news:975420919.894474_at_u250...
> Hi all.
> Could you enlighten me about dblink problem.
> If I use dblink, all indexes in a remote db are disable.
> How can I make a query faster or how can I force 'an uncle Oracle' to use
 a
> remote db indexes?
>
> Ths all.
> Waiting for reply.
> --
> Mikhail Nosov
> Russia, Togliatti
> Information Systems Design & implementation unit
> AVTOVAZ
> Tel.: +7 (8469) 34-93-34,91-91-29 (office)
> E-mail: M.Nosov_at_vaz.ru
>
>
>
>
Received on Thu Dec 14 2000 - 22:58:29 CET