What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such:
"The candidate row is fetched from the table specified in the outer query."
What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such:
"The candidate row is fetched from the table specified in the outer query."
A candidate row is a row from a table or subquery that could potentially be returned in the result set. To actually be returned it must satisfiy the WHERE and JOIN conditions.