Re: Improve SQL run time

Hi Amit ,

           Seems the table /object stats is not current there is a Full Table Scan XXPO01T_ASN_AG_LAYOUT because estimation is wrong also in Indexes XXIF01W_INTERFACE_ERRORS

On Mon, Oct 16, 2023 at 8:38 PM Amit Saroha <eramitsaroha_at_gmail.com> wrote:

> Hi All,
>
> I'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.
>
> 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
>

-- 
Asad Hasan
+91 9582111698

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