Hi Experts,
I am stuck with a problem where it need to create Index on 2 columns. The challenge here is the table is some 100GB in size and got
Some metadata which might be useful:
- Table size - 100GB
- Oracle version - 11.2.0.3.0
- Environment - OLAP (data warehouse)
- The columns contain mostly distinct values (not *all* like a PK, but majority)
- DMLs - Insert operation is usually issued on the table.
My concern(s) -
1) While the index creation process is in-progress, will the users accessing it be affected?
I mean will there be any downtime or unusual behavior faced by them ?
2) What will be the server CPU utilization during the process?
Just curious to understand how it is from the DBA standpoint.
Help much appreciated.
Thanks,
-- Ranit