Re: Query runtime is slow in view
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 2 Feb 2021 23:35:35 -0500
Message-ID: <ea4ef2d5-46f4-3827-71db-698c8951db10_at_gmail.com>
Date: Tue, 2 Feb 2021 23:35:35 -0500
Message-ID: <ea4ef2d5-46f4-3827-71db-698c8951db10_at_gmail.com>
On 2/2/21 9:07 PM, Lothar Flatz wrote:
> Hi,
>
> since it is rather late here the short answer:
> There seems to be an Index missing on po_headers_all
> (ORG_ID,ATTRIBUTE1, TYPE_LOOKUP_CODE, CLOSED_CODE,CANCEL_FLAG) .
> There is more to be said about good indexing, but not now. I will
> return to my bed.😉
>
> Regards
>
> Lothar
-- Mladen Gogala Database Consultant https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 03 2021 - 05:35:35 CET