Make it faster – Myths about SQL Performance
April 28 @ 12:30 - 13:30
Many developers don’t pay attention to database performance when implementing new applications. The functionality of the application is important, but the efficiency of the SQL queries is often ignored. The DBA (or the query optimizer) does this job later. If necessary, we can still create some indexes, add hints or adjust some database parameters. And in the Cloud, the Oracle database does everything automatically and autonomously, anyway.
Really? Unfortunately, the reality looks different. Many performance problems are caused by a poor software design, unsuitable data models or inefficient SQL statements. Correcting such issues at the end of a project or when the system is already in operation is often very costly and cannot be fixed with just a few configuration parameters.
With SQL live demos (all based on James Bond characters and movies), multiple-choice questions and some funny stories that happened to me in my job as an Oracle consultant, I will explain why the impact of performance is important in every phase of a software project. You can check yourself what you know about SQL performance tuning and which myths you still believe in.