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