SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS
Journal Title: Taikomieji tyrimai studijose ir praktikoje - Year 2017, Vol 13, Issue 1
Abstract
Although scientific literature studies different aspects of SQL query optimization the major part of researches is limited to the theoretical analysis of problems. There is a lack of researches that ground the effectiveness of SQL query optimization methods on the results of experimental testing. In light of this the aim of the current research is to assess the importance of SQL code optimization, data base indexes and structure in the creation of optimized SQL queries by means of experimental testing. The results of this research are important for the programmers of information systems, databases and other IT specialist who create information systems and analyze the data of databases. The results of experimental research can be used in high schools teaching databases.
Authors and Affiliations
Jurgita Lieponienė
TĖVO/VYRO PATIRTYS AUGINANT VAIKĄ TURINTĮ KOMPLEKSINĘ NEGALIĄ
The concept of father undoubtedly changes in society as the still changing attitudes about the "true man". It is noted that the role of the father in the family already covers not only financial stability. In addition, a...
GYVENTOJŲ PASITENKINIMAS GYVENIMO KOKYBE
Quality of life is a broad concept related to common well being of society. Researches related to measuring and evaluating quality of life have been started quite recently – in the middle of last century even though the...
MAŽAENERGIO PASTATO SIENOS-PAMATO ILGINIO ŠILUMINIO TILTELIO EFEKTYVUMO TYRIMAS
In this article, the authors carried out a research on a typical linear wall-foundation thermal bridge of a low-energy residential building, based on the principles of energy and economic efficiency. The empirical study...
APPLICATION MODEL OF ISO QUALITY STANDARDS IN A COMPANY
Despite the prevailing view that ISO quality standards are necessary, especially for companies operating on the international market, there is also a perception that the organization, when deciding to implement one of th...
ENVIRONMENTAL EFFECTS ON GROUNDWATER QUALITY IN SEYFE-KIZILIRMAK SUB-BASIN
Water is one of the most crucial natural resources. As in most regions of the world, water quality in our country continues to decrease. The objective of this study is to determine environmental effects on groundwater qu...