Hello,
When will the engine start to use new index assuming the optimizer would
like to choose it?
1- the next started transaction?
2- after reconnect to database?
3- after restart of database engine?
4- what about concurrent connections?
Regards,
...michal