![]() ![]() Microsoft SQL Server’s explain plans can be easily enabled by issuing an SQL statement which will return explain plan result-sets. The reason for the different configurations for the 3 different databases is because of the different implementations by the database vendor. ![]() DB2 should also work out of the box, which by default will create the explain tables if they do not exist but will not drop them. If you would like to manually configure and create an explain table for all of your users, you may do so and have all ADS users configure their ADS installation to access that specific table. ADS will create and drop an explain table every time the user executes a query or executes explain with a dynamic explain table name using the session id, so the explain tables are not confused by simultaneous users. ![]() For Oracle, the default settings should also work from installation. Microsoft SQL Server does not have any configurable settings and works from installation by only enabling the execution plan. Diagram objects can be repositioned to create meaningful images for others. Each operation's details can be viewed and the color of critical operations can be altered to assist in highlighting important bottlenecks and steps in the execution process. Right-Click on the contents of the Execution Plan to add that Plan to the Explain Whiteboard for a quick comparison of execution time from multiple queries in one window.Įxplain Diagrams can be generated from Execution Plans and saved as JPEG or PNG images for sharing. It is also possible to add execution plans to the Visual Explain Whiteboard. You may change the settings in the File > Options > Explaintab. The second option is to open two popup Query Windows and execute a single query in each window to be compared side-by-side.īefore you begin using visual explain you may want to review the default settings according to your database vendor and version. The first option is to "Execute Explain" on two highlighted queries at the same time, which will give you two visual explains in the results to compare. There are two ways that ADS can be used in comparing execution plans of queries. The visual explain plans have an identical layout for most databases except for the row information for each node operation, which contains specific column information according to the specific database server and version. Aqua Data Studio also provides an "Execute Explain" button in the query window which will generate an execution plan for the current query or the highlighted queries in the Query Analyzer window. Multi-execution plans are supported and executing a script will generate multiple execution plans. If this option is enabled an execution plan will be generated for each query executed in the results Execution Plan tab. Aqua Data Studio’s Visual Explain provides a visual display of an execution plan for a query, allowing for query tuning to enhance query and server performance.ĪDS provides a "Show Execution Plan" option in the Main Application Toolbar. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |