chao_ping wrote:
> Hi,
> Sorry for the in-complete information. OS is not related as this is
> purely oracle inside problem.
> Oracle version can be 8.1.7 or 9.2.0.
>
> The above SQL is just some sample, means I have to do a table full
> scan on remote database, and there is no index to use on that remote
> table. And I want to increase the full table scan efficiency for that
> remote table scan action.
>
> Thanks
You can not increase the efficiency of a FTS. An FTS is an FTS. Why not
approach this as a business problem and have someone build the required
index?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon May 23 2005 - 21:09:38 CDT
