Home » RDBMS Server » Performance Tuning » Outline help
Outline help [message #196014] Tue, 03 October 2006 12:51
Messages: 97
Registered: June 2005
Dear All,

We have a sql query which uses a dblink to access a table in another database. The remote table is indexed and pretty big (44GB). Now we did an outline for plan stability. Now if we sample run just the query without using the outline, then the query performs pretty fast and uses the index on remote table. However if we use the outline, then the query will run the full scan of the remote table and will be going on forever.

The question is why the outline finds a different execution path and over and over on my experiment, without outline, index being used and the same query outline runs the Full Scan. Does outline has limitation on its use over dblinks. Any help would be highly appreciated.

Previous Topic: 10g - gather_stats_job
Next Topic: Regarding I/O Performance
Goto Forum:

Current Time: Sun Aug 20 05:00:51 CDT 2017

Total time taken to generate the page: 0.07370 seconds