| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
