Vizualizace optimalizačního procesu v SQL Serveru

Abstract

The basis of every advanced database system is the so-called optimizer, which tries to find the most efficient execution plan for the input SQL statement. The optimization process uses a so-called memo structure, which streamlines the entire process. SQL Server allows you to list the basic form of the memo structure in text form. The memo structure can be relatively large and the text is usually confusing even for relatively simple SQL statements. The aim of this work is a graphical representation of the memo structure based on the text outputs of SQL Server.