Re: Index advice requested.

From: Frank <franjoe_at_frisurf.no>
Date: Mon, 19 Nov 2001 20:25:25 +0100
Message-ID: <73dK7.5116$B87.79716@news1.oke.nextra.no>

Hi!

Have you thought about putting your remote tables in an inline view (espescially if they are related to eachother) so that the inline view might be sent to the remote database for processing?

SELECT ??????
FROM (SELECT ????? FROM remote_table a, remote_table b WHERE...=....) v local_table a,
local_table b
WHERE v.??????= ??????
AND ...... Frank Received on Mon Nov 19 2001 - 13:25:25 CST

This message: [ Message body ]
Next message: Reinhard: "ORA-12560 on Win98"
Previous message: Eric Logsdon: "ORA-12500 setting up database connection"
In reply to: Ed Stevens: "Index advice requested."
Next in thread: Ron Reidy: "Re: Index advice requested."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US