Lothar Flatz
Diso AG
Lothar Flatz started working with Oracle Database in 1989, in the days of Version 5. He worked for Oracle Corporation for 15 years and was a member of Oracle's special forces, the Real-World Performance Group. He is an Oracle ACE, a member of the OakTable Network of Oracle scientists and specializes in performance tuning. Together with his friend Björn Engsig he holds an US Patent targeted to improve database performance.
Talks 1
Have you ever wondered about the quality of the index design in one your applications? After all, quite often the index design is done by developers who never see the database in action. How about not just fitting one index into existing complex indexes, but to create a complete new index design where everything fits together optimized as a whole. Would that not be very risky? How do you control the risk? How would you form your team? Where will you get the relevant information to do this? What tools would you use?
In the Raiders of the data dictionary series we use the information of the dictionary (e.g. the v$ views) to improve the physical database design.
4
like