The problem is like this.
I have a really complex logic in my application.
It takes nearly 30 mins to complete.
I want to reduce that time.
I have identified indexes to be created.
But i dont know the effect of these indexes on other transactions.
So i want to create these indexes dynamically inside the process and then after the process i want to drop them.