Home » RDBMS Server » Performance Tuning » Outline help
Outline help [message #196014] Tue, 03 October 2006 12:51
rkl1
Messages: 97
Registered: June 2005
Member
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.

Thanks.
Previous Topic: want to see the time duration of a statement
Next Topic: 10g - gather_stats_job
Goto Forum:
  


Current Time: Fri Dec 02 14:12:33 CST 2016

Total time taken to generate the page: 0.22671 seconds