The Oracle Optimizer - A conversation with Nigel Bayliss - Part 2
No topic quite gets emotions rolling as much as the Oracle Query Optimizer. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optimizers. In this episode, I get Nigel's thoughts on SQL Plan Management, the types the statistics that the optimizer needs now and what it might need in future, and whether setting statistics is a good idea. Keep updated with Nigel's thoughts on the optimizer at https://twitter.com/vldbb If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.