Whats the fastest way to create an index on a table with hundreds of millions of records on 12.2 Standard Edition 2.
I don't think its possible to create the index online or in parallel so, what options do I have in order to reduce the exclusive lock on the underlying table which is very time consuming?
Thanks,
O