• 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.