2 Replies Latest reply on Jan 4, 2013 11:34 AM by user8941550

    SQL Plan Management - Baseline- Can it be used in another Schema


      I have never implemented, SQL Plan Management -Creating SQL plan baselines.

      I am having a query which is using indexes in one Schema.
      On another Schema in the same DB, the query accesses the SAME TABLE THROUGH SYNONYM. And the plan is very different. And query goes into indefinite execution.
      I have tried hints and other ways but it's simply not using the indexes.

      Anyone having experience with Baselines, can you suggest if I create a Baseline for the plan in SchemaA.
      Then can I use the same plan through Baseline in SchemaB for the same query?

      Please suggest..Thanks..