All Episodes

February 18, 2022 28 mins

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 ambush Nigel with some questions that came in from Twitter from the Oracle community. In particular, how to optimize queries that contain TABLE functions, and what is best way for developers to quickly and efficiently tackle SQL tuning.

Keep updated with the optimizer at https://blogs.oracle.com/optimizer.  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.

 

Mark as Played

Advertise With Us

Popular Podcasts

Dateline NBC

Dateline NBC

Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com

24/7 News: The Latest

24/7 News: The Latest

The latest news in 4 minutes updated every hour, every day.

Therapy Gecko

Therapy Gecko

An unlicensed lizard psychologist travels the universe talking to strangers about absolutely nothing. TO CALL THE GECKO: follow me on https://www.twitch.tv/lyleforever to get a notification for when I am taking calls. I am usually live Mondays, Wednesdays, and Fridays but lately a lot of other times too. I am a gecko.

Music, radio and podcasts, all free. Listen online or download the iHeart App.

Connect

© 2025 iHeartMedia, Inc.