I updated the error if anyone can help me understand what am I doing wrong https://dba.stackexchange.com/questions/301374/oracle-forms-installation-error-inst-07545 Thanks in advance
Does anyone have any intermediate-level books/resources they can recommend about SQL optimization?
I've read the book in the link below (SQL Optimization Explained by Markus Winand). But it was pretty advanced and a few chapters were over my head/very detailed. I would benefit from having more concise guidelines about Oracle SQL performance best practices and clear instructions about how to use Oracle explain plans. I don't think explain plans and performance troubleshooting need to be as complicated as a lot of resources make them out to be.
@User1973 Learning "SQL optimisation" from books is a bit like learning motorcycle riding or woodworking from books: you can get a basic idea of what you need to do, but the rest is practice. For Oracle Database I can suggest Tom Kyte's books -- and then practice.
Good morning to everyone except our cloud infrastructure team
@mustaccio @User1973 I'd add it's important to understand the difference between index organized tables and heaps and how the effects estimation and the amount of data that has to be read. Strangely enough, sometimes it helps to think about things in very simple terms, i.e. "If this was data on pages of paper and it was organized like it was in the database, how would I find what I need" - that's helped me understand why the optimizer makes certain choices.
I wanna use this platform and all I have is a screenshot of it, I don't know if it's a website or an app. It's used for sports betting.
