Learn To Use Explain Plans in 20 minutes and Understand Your Queries - Advanced SQL

In the video I'll describe explain plans also called execution plans and how you can use them to optimize your queries. These are present in most popular DBMS like Oracle PostgreSQL, mySQL, MS SQL and DB2. Oracle explain plan documentation https://docs.oracle.com/cd/B19306_01/... SQL script to create HR schema https://github.com/TomekQ13/sql-cours... Indexes video    • Step-by-step guide to database indexes - A...   Join algorithms video    • Database Join Algorithms Explained Step-By...