May I know In real time if we are rebuilding the index of 1 billion rows in table, it takes so much time in live Production database.
Does it effect to application. I know how to rebuilt the index. But how we should do in the Production database, we have to take approval from application team or it is necessary to shutdown the live Production database?
Please assist me.
Thanks in advance.