Re: Query runtime is slow in view
Date: Tue, 2 Feb 2021 23:35:35 -0500
Message-ID: <ea4ef2d5-46f4-3827-71db-698c8951db10_at_gmail.com>
Of course, if you have the right version of the database, the indexes
can be automagically created for you. That's sort of the database
version of a self driving car. Self driving car would leave state
troopers jobless. Self-indexing databases may do the same for the
application architects, unless Oracle doesn't build the sense of humor
into the database. It desperately needs one. Oracle 25p, the "p" stands
for "prankster".
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