Re: Remote table performance on complex queries/views

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 12 Sep 2016 20:40:36 -0400

On 09/12/2016 04:28 PM, Rich J wrote:


Is there something from the optimizer point-of-view that I may have missed? Any other tricks of tweaking to get the last 10% improvement (instead of the 95% improvement by reworking the vendor app)?

Any pointers are appreciated!  TIA!
Rich

Can you create a materialized view? Materialized view would eliminate remote query and speed the application up, while maintaining the dependency.

Regards


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2016