We had a vendor application where the vendor fully-cached the database and it had massive performance problems. Mike and I applied function-based indexes, stored outlines, changes to the optimizer paramers, and the whole application ran 3x faster, in just a few days, without touching a single line of the application code.
For more information on Oracle Silver Bullets, see my latest book:
I’m almost finished with my intensive scuba class, and I soon hope to become a PADI certified open water diver, like Mike:
Dive school is incredibly rigorous, but I still have what it takes. . . .
