2 Replies Latest reply: Jan 4, 2013 5:34 AM by user8941550 RSS

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