Force Oracle to return TOP N rows with SKIP LOCKED
“From what I have seen, Oracle applies the WHERE predicate before determining what rows to skip.” Yup. It is the only possible way. You can’t skip a row from a resultset until you have determined the resultset. The answer is simply not to limit the number of rows returned by the SELECT statement. You can … Read more