Dear Gurus,
We have isue during mv refresh , we see spike of Cpu waits , we see
recursive querys are top waiting for cpu
We see two plan for recursive querys , one is using FTS and other is Index
range Scan ,Need to understand , is attaching good plan for recursive query
is fine , or it is not good practise to follow for recursive query and
does it can creates any issue
Regards,
Krish