The #SQL #Optimizer runs your SQL with a variety of options that include various hints and SQL rewrites to find the optimal performing SQL rather automatically.
Query #optimization is a function of many relational #database management systems. The #query optimizer attempts to determine the most efficient way to execute a given query by considering the possible query plans.
00:00 Database Optimizer
01:11 How plan is generated & optimizer calculates LCM?
Website: https://www.dbagenesis.com/
Facebook: https://www.facebook.com/dbagenesis/
Instagram: https://www.instagram.com/dbagenesis/
Twitter: https://twitter.com/DbaGenesis
