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ė

Keywords

Related Articles

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...

Download PDF file
  • EP ID EP573179
  • DOI -
  • Views 159
  • Downloads 0

How To Cite

Jurgita Lieponienė (2017). SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS. Taikomieji tyrimai studijose ir praktikoje, 13(1), 94-101. https://europub.co.uk/articles/-A-573179