Chris Saxon

I’m Chris Saxon; an Oracle Developer Advocate for SQL. My job is to help you get the best out of the Oracle Database and have fun with SQL!

To help you with this I blog at All Things SQL. I also create videos combining SQL and magic on YouTube at the The Magic of SQL.

If you have questions about working with Oracle technology; please reach out to me. You can do this via Twitter or on Ask Tom.

During ConTech2021 Chris Saxon will present Crimes Against SQL

Abstract:
There are many SQL anti-patterns that will still lead to slow queries.

Three of the most common are concatenating user input into SQL; placing SQL inside loops; and using the same table many times in one query. Join this session to learn why these are slow and what to do instead
Description:
Oracle Autonomous Database includes many tools to self-optimize slow-running SQL statements. But no matter how good the database gets; there are many SQL anti-patterns that will lead to slow applications.

This session covers three of the worst offenders: concatenating user input into statements; placing SQL inside loops; and accessing the same table many times in one query.

Join this talk to learn why these lead to slow data access and how using PL/SQL helps you avoid these problems to build better; faster; more secure data-driven applications.