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. |