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.
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-lReceived on Wed May 30 2012 - 10:38:34 CDT