Processing new rows in staging table quickly...
From: <post.ethan_at_gmail.com>
Date: Wed, 17 Apr 2019 18:31:37 -0500
Message-ID: <010d01d4f575$b4821630$1d864290$_at_gmail.com>
I have a staging table in which 99% of the rows are going to have a date for stats_processed_time.
Date: Wed, 17 Apr 2019 18:31:37 -0500
Message-ID: <010d01d4f575$b4821630$1d864290$_at_gmail.com>
I have a staging table in which 99% of the rows are going to have a date for stats_processed_time.
I will need to only select for rows that have not been processed.
What is the best strategy here? Should I allow nulls and select like below? Or should I put a date, way out in the future, say 2099, and select for that instead and then update to correct data once things are processed? Perhaps allow nulls and a bitmap or FBI solution (I would like to avoid solutions which can't be ported to Postgres.)
.
where b.access_key=v_access_key
and b.bucket=v_bucket
and b.stats_processed_time is null
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 18 2019 - 01:31:37 CEST