Oracle db optimizer

From: Jack <>
Date: Mon, 19 May 2014 09:24:24 +0300
Message-ID: <sshev.40752$>

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

Original text of this message