Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
Patch
Description
Oozie workflow processing becomes slow after the increase of rows in WF_JOBS and WF_ACTIONS tables when running against SQL Server. A secondary index need to be created against WF_JOBS (created_time), WF_ACTIONS (last_check_time & pending) to avoid going for a full table scan when querying against these fields.