Database Tuning (MOSC)

MOSC Banner

update query is running slow

edited Jun 20, 2012 7:39PM in Database Tuning (MOSC) 2 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center