RE: View vs. Synonym (across DBLink)

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 31 Jan 2005 12:31:58 -0500
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E755@usahm236.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Knight, Jon Sent: Monday, January 31, 2005 12:13 PM
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:38 CST