SQL Horror Queries
Dani Schnider will join us for this session to discuss how to avoid SQL "horror" queries:
SQL is a powerful and efficient query language when used correctly. But inefficient and inappropriate SQL statements can cause massive performance problems. Instead of solving such issues with additional indexes, optimizer hints, SQL profiles or SQL plan baselines, a much better and more sustainable solution is often to rewrite the SQL statements and to reduce the complexity of the queries.
During performance tuning tasks for my customers, I’m often confronted with complex SQL statements. Many of these statements were developed years ago and changed several times by people that either had not enough SQL skills or had not the time to understand the original query in detail. This can lead to queries that are not only very slow, but also hard to understand - for the developers as well as for the query optimizer. By transforming these SQL statements into simpler queries, the optimizer can calculate better estimations and generate faster execution plans.
In this presentation, some real-life examples of terrible "horror queries" will be shown and rewritten into simpler, more elegant and faster SQL statements. The goal of the presentation is to show how to improve the performance of a query by factors with appropriate SQL statements and powerful Oracle SQL.
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
https://asktom.oracle.com/
Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit
On this page of the site you can watch the video online SQL Horror Queries with a duration of hours minute second in good quality, which was uploaded by the user Oracle Developers 20 March 2020, share the link with friends and acquaintances, this video has already been watched 2,108 times on youtube and it was liked by 46 viewers. Enjoy your viewing!
