d and work_order_no != 'CORPORATE';
Regards,
Abbas
On Mon, May 21, 2018 at 3:43 PM, pavan95
wrote:
Hi mlunon,
A great thanks for your timely response. And yes it worked when I
rewritten
the query.
The query got enhanced with approximate of 1000 planner seeks. You
can find
it f
is 1; so:
floor(1.15) + ( (1.15 - floor(1.15)) / 0.6 ) = 1 + ( (1.15 - 1) / 0.6 )
= 1 + ( 0.15 / 0.60 ) = 1.25
Hope it helps. Feel free to ask a question if it's still unclear. :)
On Mon, May 21, 2018 at 6:09 PM, pavan95
wrote:
Hi Abbas,
Thanks for your valuable suggestions. To my surprise