Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!

2018-05-21 Thread Abbas
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

Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!

2018-05-21 Thread Abbas
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