update query is running slow
Database version 11.2.0.2
Update query
UPDATE ps_jrnl_ln a
SET a.jrnl_line_status = '1'
WHERE a.project_id = ' '
AND a.account IN (
SELECT DISTINCT c.account
FROM PSTREENODE A
, PSTREELEAF B
, PS_OI_NODE_BAL_PC G
, PS_GL_ACCOUNT_TBL C
WHERE A.EFFDT = (
SELECT MAX(X.EFFDT)
FROM PSTREEDEFN X
WHERE A.SETID = X.SETID
AND A.TREE_NAME = X.TREE_NAME)
AND B.SETID = A.SETID
AND A.TREE_NODE = G.TREE_NODE
AND A.TREE_NAME = G.TREE_NAME
AND g.activeflag = 1
AND B.TREE_NAME = A.TREE_NAME
AND B.EFFDT = A.EFFDT
Update query
UPDATE ps_jrnl_ln a
SET a.jrnl_line_status = '1'
WHERE a.project_id = ' '
AND a.account IN (
SELECT DISTINCT c.account
FROM PSTREENODE A
, PSTREELEAF B
, PS_OI_NODE_BAL_PC G
, PS_GL_ACCOUNT_TBL C
WHERE A.EFFDT = (
SELECT MAX(X.EFFDT)
FROM PSTREEDEFN X
WHERE A.SETID = X.SETID
AND A.TREE_NAME = X.TREE_NAME)
AND B.SETID = A.SETID
AND A.TREE_NODE = G.TREE_NODE
AND A.TREE_NAME = G.TREE_NAME
AND g.activeflag = 1
AND B.TREE_NAME = A.TREE_NAME
AND B.EFFDT = A.EFFDT
0