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!
During ConTech2021 Chris Saxon will present Crimes Against SQL
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
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.