Re: inefficient sql

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


Other related posts: