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 143
- Downloads 0
THE PECULIARITIES OF LEXICAL TRANSLATION TRANSFORMATIONS IN BUSINESS JOURNALS
The paper deals with the peculiarities of lexical translation transformations in business journals. The novelty of this work is the investigation of the usage of lexical translation transformations in business language t...
KOSMETOLOGŲ/GROŽIO TERAPEUTŲ VEIKLA KLIENTĖS NĖŠTUMO IR ŽINDYMO LAIKOTARPIU
The article analyzes the safe choice of cosmetic procedures and cosmetics during pregnancy and breast-feeding. During pregnancy women often face with skin problems such as pigmentation, rashes, telangiectasia and other...
BEGINNING TEACHER MENTORING IN ESTONIA: A BASIC REVIEW OF THE CURRENT STATE AND SUGGESTIONS FOR IMPROVEMENT
As a downside, research shows that high-quality mentoring is rare. In 2017, more than dozen years after the launch of the induction program, a survey was initiated by the NGO Alustavat Õpetajat Toetav Kool. The character...
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...
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...