I am trying to delete the non PI column from the pi column of the same table.
Query as below.
Thanks for the Responce Todd.
Its a TYPO here the condition is tbl1.non-PI is not null.
Can you give me solution to solve the issue.
It would help if the whole Explain plan was available. The step above is spooling the tbl1 copy of the table and qualifying on the date range. There is no qualification on "tbl1.non-PI is not null" in the outer query, only inside the subquery.