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
- EP ID EP573179
- DOI -
- Views 161
- Downloads 0
PAŽANGIŲJŲ MATAVIMŲ SISTEMŲ DIEGIMO PROBLEMATIKA DARBUOTOJŲ KOMPETENCIJŲ KONTEKSTE
The adoption of energy efficiency measures is shifting the building installation industry towards green technologies, such as smart metering and home automation, bringing significant changes on workplace requirements and...
GAMYBOS ĮMONĖS ATSARGŲ APSKAITOS TYRIMAS
Each company, as a profit-making entity, has the main objective of maximizing profits. The company's purpose is greatly influenced by its available current assets. In the manufacturing company, the largest part of curre...
KOLEGIJOS STUDENTŲ PSICHOEMOCINĖ SAVIJAUTA
The World Health Organization has stated that the last few years, the youth mental health disorders, such as anxiety, depression, eating disorders and selfharm, were increased. Student mental health is a concern for the...
DARBUOTOJŲ VERSLUMĄ ĮGALINANTI APLINKA: TEORINĖS ĮŽVALGOS
The aim of the article is to substantiate theoretically the features of the environment, which empowers employee entrepreneurship. In the first part of the article, the concept of empowerment is analysed. The second part...
JUOSTINIO PAMATO ILGINIO ŠILUMINIO TILTELIO EFEKTYVUMO TYRIMAS A+ KLASĖS PASTATUOSE
In this article, the authors carried out a research on a typical linear shallow foundation thermal bridge of class A+ residential building, based on the principles of energy and economic efficiency. The thermodynamic stu...