Unlikely, but to find out for sure. Run an explain plan and see how Oracle is solving the query. Create a synonym and substitute the synonym into the query then rerun the plan. Compare. Make sure to make no other changes during the test. HTH -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Knight, Jon Sent: Monday, January 31, 2005 12:13 PM To: Oracle-L@xxxxxxxxxxxxx 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 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l