This content has been marked as final. Show 3 replies
Hi this is the Oracle Designer forum. You may be better off over at the database place1 person found this helpful
Can you please make sure index are utilized well in your Oracle 11g Database environment.Also gather statistics on all the required objects after index rebuild.Hope queries should run to optimal after this is done...
Thanks I will move to the correct one..
Build the Indexes and it is still slow. I am querying from a view from another database, which is in 10g instances.
Moved: Query can run in Oracle 10g but very slow in 11g
Edited by: 924400 on Apr 1, 2012 6:03 PM
Edited by: 924400 on Apr 1, 2012 6:26 PM