Re: inefficient sql

From: Bruno Lavoie <bruno.lavoie_at_gmail.com>
Date: Wed, 30 May 2012 11:38:34 -0400
Message-ID: <4FC63EFA.8040005_at_gmail.com>



Also, if you automate efficiency detection be careful with formulas like : rows in resultset / lios
Use of aggregations can diminishes a lot final rows of resultset, the most important is to detect the high lios per rows by row source step in plan.

Good luck
Bruno Lavoie

Le 2012-05-29 16:39, Ric Van Dyke a écrit :
> tart with<number of rows in result set> /
> LIOs. If this is 10 or less then you it's likely alright, anything over
> certainly needs to be looked at.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 30 2012 - 10:38:34 CDT

Original text of this message