Simon Riggs wrote:
> The idea of auto rebuilding indexes following recovery has already been
> proposed, so is under consideration. It hasn't been proposed in relation
> to the use case you mention, so that is new.
>
> If we did as you suggest then it would speed up the base backup but
> would also add index rebuild time onto the end of any recovery.
Forgive me for being stupid, but isn't a time when all the data for
a table is being streamed in, during restore, the *perfect* time
to build an index? Why wait until after the restore?
Cheers,
Jeremy