Re: RELICATION QUESTIONS
From: Laconic2 <laconic2_at_comcast.net>
Date: Sat, 19 Jun 2004 14:26:52 -0400
Message-ID: <0aidnd_xYv2NGEnd4p2dnA_at_comcast.com>
Date: Sat, 19 Jun 2004 14:26:52 -0400
Message-ID: <0aidnd_xYv2NGEnd4p2dnA_at_comcast.com>
Is Oracle using the same optimizer in both
instances?
Received on Sat Jun 19 2004 - 20:26:52 CEST"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