Re: Help with a VIEW

John:

Unfortunately, I dont know how to help you, but I have encountered this problem as well. One thing you cah check though to use use sqlplus and set autotrace on ( you'll have to create the plan table first) and compare the execution plan for the query on both systems to see that they are the same. If they are identical, then you are having the problem we are also having. If not, then the optimizer is chosing a different execution plan in one database: try analyzing the schema.

In any case, let me know if you resolve this issue: dcowden_at_aautomation.com or cowden_at_earthlink.net
thanks
Dave
John Alden wrote in message <7fsmd1$ecf$1_at_linux2.inet.maherterminals.com>...
>Here is my dilemma:
>Platform: WindowsNT4 - Oracle8
>I have two seperate databases on two seperate machines with identical
>schemas , tables, etc...
>When querying one table with the view it is fast.... the other slowwwwwwww
>Is there something in the settings or that i might be missing
>any suggestion would be welcome.....
>Thanks in advance - Confused in Millburn,NJ
>
>
>
Received on Mon Apr 26 1999 - 22:22:28 CDT