Re: RELICATION QUESTIONS
From: Paul <paul821_at_yahoo.com>
Date: Sat, 19 Jun 2004 22:59:00 GMT
Message-ID: <Uy3Bc.27333$V57.6521526_at_news4.srv.hcvlny.cv.net>
Date: Sat, 19 Jun 2004 22:59:00 GMT
Message-ID: <Uy3Bc.27333$V57.6521526_at_news4.srv.hcvlny.cv.net>
Yes:
The tables have the same data and I get the
same results back. The production database returns data faster because it
is using all indexes. The replication database is slower because it is not
using indexes. However the indexes are all there. All tables have
been analyzed also.
Received on Sun Jun 20 2004 - 00:59:00 CEST"Laconic2" <laconic2_at_comcast.net> wrote in message news:MO6dnSy_G4hQJUndRVn-sw_at_comcast.com...And do you get the same results from the query in both databases? Are they loaded with the same data?"Paul" <paul821_at_yahoo.com> wrote in message news:CR0Bc.26057$V57.6008237_at_news4.srv.hcvlny.cv.net...Yes, I forgot to mention that both databases are using the cost based optimizer."Laconic2" <laconic2_at_comcast.net> wrote in message news:0aidnd_xYv2NGEnd4p2dnA_at_comcast.com...Is Oracle using the same optimizer in both instances?"Paul" <paul821_at_yahoo.com> wrote in message news:CLXAc.21694$V57.5004971_at_news4.srv.hcvlny.cv.net...I have two databases (8.1.7), one master and one replicated. I'm getting different results in my explain plan from the same query. Both dbs have the same indexes and all tables have been analyzed.I'm using all the indexes I should on the master db but not on the replicated db. Does anyone have any ideas why the optimizer is behaving differently in the two databases?Thank you.
--
Paul