Re: Oracle db optimizer

From: joel garry <>
Date: Mon, 19 May 2014 08:58:16 -0700 (PDT)
Message-ID: <>

On Monday, May 19, 2014 5:59:52 AM UTC-7, Jack wrote:
> "Jack" wrote in message news:sshev.40752$

This isn't really enough information to say, but for whatever reason your BS table doing a full scan is a much better plan than a bunch of nested loops. One could guess the statistics or lack of statistics in the XE is responsible for that, but better to know than guess. Here is one simple methodology for giving us enough information to tell - and you may work it out just following the steps. Ignore the formatting advice, of course.

This all assumes you've gotten the basics from the performance tuning manual. Jonathan Lewis has a book that explains it in detail, highly recommended.


-- is bogus.
Received on Mon May 19 2014 - 17:58:16 CEST

Original text of this message