Re: Number of files in an Instance?

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/03/04
Message-ID: <19970304121601.HAA14437@ladder01.news.aol.com>#1/1

Also asked >>
> Can you do union in view across instances and gain the optimizer
> advantages?

<<

The simple answer is NO. You can code distributed tables in a view, but the query will be broken into parts with a part ran on each referenced instance. If each portion of the query has indexed column constants or single values available then you can get selective results from the remote instance. However, if this is not the case then normally Oracle does a full table scan on the remote table and brings the results into the instance where the query is being ran for use in determining the final result set.

Be as selective as possible on the distributed portion of a query.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Mar 04 1997 - 00:00:00 CST