CHAPTER 2
The Cost-Based Optimizer Environment
When I’m solving tricky tuning problems, I’m often reminded of the story of the alien who came to earth to try his hand at driving. He’d read all about it and knew the physics involved in the engine. It sounded like fun. He sat down in the driver’s seat and turned the ignition; the engine ticked over nicely, and the electrics were on. He put his seatbelt on and tentatively pressed the accelerator pedal. Nothing happened. Ah! Maybe the handbrake was on. He released the handbrake and pressed the accelerator again. Nothing happened. Later, standing back from the car and wondering why he couldn’t get ...
Get Oracle SQL Tuning with Oracle SQLTXPLAIN now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
