RE: View vs. Synonym (across DBLink)

From: Parker, Matthew <matthewp_at_amazon.com>
Date: Mon, 31 Jan 2005 09:31:22 -0800
Message-ID: <F385925F530F6C4081F1659F71640EB301CC76D9@ex-mail-sea-04.ant.amazon.com>

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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Knight, Jon Sent: Monday, January 31, 2005 9:13 AM
To: Oracle-L_at_freelists.org
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_at_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 Received on Mon Jan 31 2005 - 12:34:06 CST