Re: inefficient sql

  • From: Bruno Lavoie <bruno.lavoie@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 30 May 2012 11:38:34 -0400

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 

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.


Other related posts: