select nodeId,nodeName,taskflowName,taskflowVersion 
from ( 			
	select /*+ use_hash(n f) ordered */ n.ID nodeId,n.name nodeName,f.name taskflowName,f.version taskflowVersion 
	from "AB" n, "BC_3" f 			
	where 			n.owner = ? 			and n.STATUS in 			(   				? 			) 			and n.GMT_MODIFIED < ? 			and n.IS_AUTO = 'Y' 			and n.task_flow_id = f.id 			order by f.priority desc nulls last, f.gmt_create asc 		) where rownum < ?   	



  

---------------------------
SELECT nodeId, nodeName, taskflowName, taskflowVersion
FROM (
	SELECT /*+ use_hash(n f) ordered */ n.ID AS nodeId, n.name AS nodeName, f.name AS taskflowName, f.version AS taskflowVersion
	FROM "AB" n, "BC_3" f
	WHERE n.owner = ?
		AND n.STATUS IN (?)
		AND n.GMT_MODIFIED < ?
		AND n.IS_AUTO = 'Y'
		AND n.task_flow_id = f.id
	ORDER BY f.priority DESC NULLS LAST, f.gmt_create ASC
)
WHERE rownum < ?