Michal Rzewuski wrote:

> Hello,
> When will the engine start to use new index assuming the optimizer would
> like to choose it?

For inserts, updates, and deletes, the engine (all architectures) starts
using the new index immediately. If that didn't happen, the index would
become out of sync as soon as an update happened. Selects will also be
re-optimized as soon as the index is created.

Regards,


Ann