Hi Community,
I want to understand and confirm whether it is expected behavior that a
long running index creation will capture all in-flight new rows to the data
table while the index creation is still in progress.
i.e. when I issue CREATE INDEX there are only 1 million rows
after I issued CREATE
There will be 10 millions rows. After the index metadata is created we run
an UPSERT SELECT (with a SCN at which the data table was resolved) to
create index rows for all existing data rows. Any new rows that are written
to the data table after the index metadata is created will be written to
the i
