MIME-Version: 1.0
References: <CAG67e6R+98Q-xRWHmaEsDcRBNLzEdPuDD5pxrDTn95M68GFSJA@mail.gmail.com>
 <29cb9cfe-c512-4eef-995a-e20aa6f6f108@bluewin.ch>
In-Reply-To: <29cb9cfe-c512-4eef-995a-e20aa6f6f108@bluewin.ch>
From: Amit Saroha <eramitsaroha@gmail.com>
Date: Mon, 16 Oct 2023 12:11:27 -0400
Message-ID: <CAG67e6QGRipKsvuSo8KntcuHxJT=kO-YGqQ4231=aFMLsCJ=oA@mail.gmail.com>
Subject: Re: Improve SQL run time
To: Lothar Flatz <l.flatz@bluewin.ch>
Cc: "ORACLE-L (oracle-l@freelists.org)" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="0000000000003264d20607d7abe3"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: eramitsaroha@gmail.com
--0000000000003264d20607d7abe3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Lothar,

Thank you for the valuable feedback.

I'll make the adjustments provided in the example and see how things
proceed.

Best Regards,
AMIT SAROHA


On Mon, Oct 16, 2023 at 11:39=E2=80=AFAM Lothar Flatz <l.flatz@bluewin.ch> =
wrote:

> Estimates are way wrong indexing could be improved.
> But since most of the time is spend on line 9-12 I would look first into
> elimination the select max(subquery) by using an analytic function as in
> this example:
>
>
> https://forums.oracle.com/ords/apexds/post/analytic-function-vs-subquery-=
8485
>
> Thanks
>
> Lothar
>
> Am 16.10.2023 um 17:07 schrieb Amit Saroha:
>
> Hi All,
>
> I'm executing the enclosed query and want to minimize the response time t=
o
> 10 seconds. The SQL monitor, SQL, and SQL Plan are enclosed for your
> feedback.
>
> Please evaluate and provide feedback and if more information is needed,
> please let me know.
>
> Thank you for your help in advance.
>
> Best Regards,
> Amit
>
>
>

--0000000000003264d20607d7abe3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi=C2=A0Lothar,<div><br></div><div>Thank you for the valua=
ble feedback.</div><div><br></div><div>I&#39;ll make the adjustments provid=
ed in the example and see how things proceed.</div><div><br clear=3D"all"><=
div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_sign=
ature"><div dir=3D"ltr">Best Regards,<div>AMIT SAROHA</div></div></div></di=
v><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"=
gmail_attr">On Mon, Oct 16, 2023 at 11:39=E2=80=AFAM Lothar Flatz &lt;<a hr=
ef=3D"mailto:l.flatz@bluewin.ch">l.flatz@bluewin.ch</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <div>Estimates are way wrong indexing could
      be improved.<br>
      But since most of the time is spend on line 9-12 I would look
      first into elimination the select max(subquery) by using an
      analytic function as in this example:<br>
      <br>
<a href=3D"https://forums.oracle.com/ords/apexds/post/analytic-function-vs-=
subquery-8485" target=3D"_blank">https://forums.oracle.com/ords/apexds/post=
/analytic-function-vs-subquery-8485</a><br>
      <br>
      Thanks<br>
      <br>
      Lothar<br>
      <br>
      Am 16.10.2023 um 17:07 schrieb Amit Saroha:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"ltr">Hi All,
        <div><br>
        </div>
        <div>I&#39;m executing the enclosed query and want to minimize the
          response time to 10 seconds. The SQL monitor, SQL, and SQL
          Plan are enclosed for your feedback.<br>
          <br>
          Please evaluate and provide feedback and if more
          information=C2=A0is needed, please let me know.<br>
        </div>
        <div><br>
        </div>
        <div>Thank you for your help in advance.</div>
        <div><br clear=3D"all">
          <div>
            <div dir=3D"ltr" class=3D"gmail_signature">
              <div dir=3D"ltr">Best Regards,
                <div>Amit</div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </div>

</blockquote></div>

--0000000000003264d20607d7abe3--
--
http://www.freelists.org/webpage/oracle-l