Re: Query runtime is slow in view

Although the indexing is the low hanging fruit in tuning I would disagree that it is the only obligation of application architects. Guess there would be some need for them still.

Am 03.02.2021 um 05:35 schrieb Mladen Gogala:
> 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
>

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