Evaluation of Sub Query Performance in SQL Server
The paper explores several sub query methods used in a query and their impact on the query performance. The study uses experimental approach to evaluate the performance of each sub query methods combined with indexing strategy. The sub query methods consist of in, exists, relational operator and re...
Main Authors: | Oktavia Tanty, Sujarwo Surya |
---|---|
Format: | Article |
Language: | English |
Published: |
EDP Sciences
2014-03-01
|
Series: | EPJ Web of Conferences |
Subjects: | |
Online Access: | http://dx.doi.org/10.1051/epjconf/20146800033 |
Similar Items
-
Optimizing queries in SQL Server 2008
by: Ion LUNGU, et al.
Published: (2010-05-01) -
Improving SQL Server Perform
by: Nicolae MERCIOIU, et al.
Published: (2010-01-01) -
INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES
by: Radosław BOROŃSKI
Published: (2012-06-01) -
TEMPORAL QUERY PROCESSIG USING SQL SERVER
by: Mastan Vali Shaik, et al.
Published: (2017-12-01) -
SQL UŽKLAUSŲ OPTIMIZAVIMO TYRIMAS = SQL QUERY OPTIMIZATION RESEARCH
by: Jurgita Lieponienė
Published: (2017-12-01)