Re: different explain plan on production & test DB

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Mon, 22 Mar 2004 09:02:37 -0500
Message-ID: <dmC7c.7240$re.600454@news20.bellglobal.com>

"Joe" <joenix_1_at_hotmail.com> a écrit dans le message de news:ebfcac26.0403220459.62214b49_at_posting.google.com...
> Hi,
>
> Our production database has been copied to our test database a while
> ago, so the contents should be rather similar regarding to number of
> rows etc.
>
> For a heavy SQL I get a completely different explain plan on test than
> on production. What are possible reasons??
>
> - indexes seem to be identicatal
> - statistics are up to date
> ...

Number of CPUs on target host, memory sizing (Eg: SGA) Received on Mon Mar 22 2004 - 08:02:37 CST