Explain the query and look at the "other" column in the plan_table for = the query being executed across the db_link. It will show you in most = cases the query that is being used across the db_link. You can then = determine if Oracle is misinterpreting the view and not passes the where = clause components against that object to the other remote database. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Knight, Jon Sent: Monday, January 31, 2005 9:13 AM 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