Re: inefficient sql

From: Bruno Lavoie <>
Date: Wed, 30 May 2012 11:38:34 -0400
Message-ID: <>

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.

Received on Wed May 30 2012 - 10:38:34 CDT

Original text of this message