The optimization of SQL queries by means of drawing up query diagrams
Journal Title: Computer Science and Mathematical Modelling - Year 2011, Vol 0, Issue 7
Abstract
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. The best method to manage with this problem is performing SQL tuning. There are two basic issues to focus on during tuning: how to find and interpret the execution plan of an SQL statement and how to change a SQL query to get a specific alternate execution plan. But most important is how to find the optimal execution plan for the query to use. This article describes a timesaving method developed for finding the optimum execution plan – rapidly and systematically – regardless of the complexity of the SQL query or the database platform being used. It explains how to understand and control SQL execution plan and how to diagram SQL queries to deduce the best execution plan for a query.
Authors and Affiliations
Katarzyna Witan
Keywords
Related Articles
- EP ID EP63180
- DOI -
- Views 159
- Downloads 0
Optimal Resource Allocation for Reliability of Modular Software Systems
Considerable development resources are consumed during the software-testing phase. The software development manager has to decide how to use the testing-resources effectively in order to maximize the software quality and...
Introducing Enterprise Architecture Framework in Statistics Poland
Article is devoted to the modernization of the statistical production process. The starting point for formulating the principles and methods of the modernization is to establish a framework architecture. An in-depth anal...
Zaawansowane metody przygotowania danych terenowych do symulatora szczebla taktycznego VBS2
Artykuł zawiera opis procesu wytwarzania danych terenowych dla szczebla taktycznego VBS2. Zaprezentowano model terenu wykorzystywany w tym symulatorze oraz formaty danych terenowych, na podstawie których generowany może...
Evaluation of the expert system as a stage of the life cycle model ESDLC on the example of WIKex
The simulator of the examination process of qualitative characteristics of medical diagnoses generated by the computer medical decisions support system
The article presents a simulation tool designed to examine selected qualitative characteristics of medical diagnoses, generated by the computer system supporting medical decisions. The system uses diagnostic conclusion m...