From: Paul <paul821_at_yahoo.com>
Date: Sat, 19 Jun 2004 14:06:26 GMT
Message-ID: <CLXAc.21694$V57.5004971_at_news4.srv.hcvlny.cv.net>
--
Paul
Received on Sat Jun 19 2004 - 16:06:26 CEST
Date: Sat, 19 Jun 2004 14:06:26 GMT
Message-ID: <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