Oracle db optimizer
From: Jack <none_at_invalid.com>
Date: Mon, 19 May 2014 09:24:24 +0300
Message-ID: <sshev.40752$SH2.19490_at_uutiset.elisa.fi>
Issue: Query in production 9.2.08 b´atabase run for ever (>5min, perhaps 20min?), in devolepment 11.2 xe db it runs in 3sec.
Date: Mon, 19 May 2014 09:24:24 +0300
Message-ID: <sshev.40752$SH2.19490_at_uutiset.elisa.fi>
Issue: Query in production 9.2.08 b´atabase run for ever (>5min, perhaps 20min?), in devolepment 11.2 xe db it runs in 3sec.
It is complex view/function system.
9db not analyzed.
/*+ ALL_ROWS */ hint does not fix it this time.
Well. yes, I have proposed to updrade db, perhaps some day. Received on Mon May 19 2014 - 08:24:24 CEST