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 150
- Downloads 0
Time-based deterministic model of information security of a business organization
Concept of Usage of Bayesian Networks in Clinical Decision Support Module
Concept of decision support module utilizing a repository of clinical pathways has been presented in this paper: the definition of Bayesian networks and its major concepts, description of chosen inference algorithm and a...
Presorting as a method of acceleration of algorithms in multi-objective optimization problems
The paper presents a method of algorithms acceleration for determining Pareto-optimal solutions (Pareto Front) multi-criteria optimization tasks, consisting of pre-ordering (presorting) set of feasible solutions. It is p...
Czy sieci rządzą światem? Od Eulera do Barabasiego
W pracy poruszono problem różnorodnych zastosowań modeli i metod teorii grafów i sieci. W szczególności zwrócono uwagę na cechy charakterystyczne współczesnych sieci rzeczywistych. Przeanalizowano, w jaki sposób modeluje...
Applicability analysis of selected standards to architecture modelling of information system for health service
The article presents results of standards’ analysis BPMN, GELLO, UML, OCL, XML and HL7 in context of their applicability to software system architecture modelling. Mentioned standards are assessed from software system mo...