Re: View vs. Synonym (across DBLink)
- From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 31 Jan 2005 20:48:22 +0200
You may want to check where most of the data is.
There is a hint to use the remote table as driving table for the query. I
think it is "driving_table".
I used it once and it made a huge difference.
Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "Knight, Jon" <jknight@xxxxxxxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Sent: Monday, January 31, 2005 7:12 PM
Subject: View vs. Synonym (across DBLink)
> While tuning a mammoth query, I noticed that one of the tables in the
from
> clause is actually a view. It's defined as "select * from
> table_name@dblink". Is there any reason to believe I could improve
> performance by dropping the view and using a synonym instead?
>
> Thanks,
> Jon Knight
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
