Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: different explain plan on production & test DB

Re: different explain plan on production & test DB

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Mon, 22 Mar 2004 14:32:24 +0100
Message-ID: <c3mprr$blj$2@news.mch.sbs.de>

> - statistics are up to date

... but maybe different enough to cross an optimizers limit (e.g. a index selectivity limit).

Or other optimizer influencing topics (CPU count, other undocumented ...).

Stephan Received on Mon Mar 22 2004 - 07:32:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US