Review
Geraldo Peralta, February 13, 2019 - 4:58 pm UTC
Great!
Thanks for the quick response. I'll do it.
Review
Geraldo Peralta, February 13, 2019 - 9:13 pm UTC
Chris.
About what you wrote:
Note Oracle Database doesn't index rows where every indexed column is null and - Set it to null once you've processed a row
In my query I have other where conditions. Still is better to set the value to null once processed?
February 14, 2019 - 11:13 am UTC
Over time I would the number of to_process rows become a minuscule fraction of the rows in the table.
Thus an index on just this column should be able to efficiently find rows, even if you have other conditions in your where clause.
Review
Geraldo Peralta, February 14, 2019 - 11:42 am UTC
Got it!
Thanks, Chris.