1 Reply Latest reply on Aug 11, 2017 8:24 PM by mdtaylor

    Impact of Gather Schema Statistics request in EBS?

    Richa

      Hello Everyone

      What is the use and impact of Gather Schema Statistics request in EBS?

      If some report is already running from long time and we want to run Gather Schema Statistics request side by side, what will happen and effect?

       

      Thanks

        • 1. Re: Impact of Gather Schema Statistics request in EBS?
          mdtaylor

          Depending on the size of your EBS and number of CPUs available and degree selected on the request, users may feel the impact of gather schema statistics running.  Also ASCP Plans are incompatible with gather schema statistics so they will remain in pending status until it completes.  Your long running request will not "see" the new statistics until it completes and runs again.