Hi, please help me in optimising this update query it staking more than 6 hrs or so still not geting result.
set datediff= Web_Registration_Start_Dt - Xref_Create_Dt;
where Web_Registration_Start_Dt between '2011-12-25' and '2012-01-28'
can you also share the explain?
from the plain SQL it should be something like this
1) First, we lock a distinct xxx"pseudo table" for write on
a RowHash to prevent global deadlock for xxx.tab_t.
2) Next, we lock xxx.tab_t for write.
3) We do an all-AMPs UPDATE from xxx.tab_t by way of an
all-rows scan with a condition of ("xxx.tab_t.a <= 5").
4) Finally, we send out an END TRANSACTION step to all AMPs involved
in processing the request.
-> No rows are returned to the user as the result of statement 1.
not yet found optimised result
You need to share more info if you want support from other people.
Would be good to see
The DDL of the table
Row counts - whole table, where conditions
explain of the statement
Do you have viewpoint access? Did you checked the state of the query?