Evaluation of Sub Query Performance in SQL Server
1 School of Information System, Bina Nusantara University, Jl. K.H. Syahdan No. 9 Palmerah Jakarta 11480 Indonesia
2 School of Computer Science, Bina Nusantara University, Jl. Kebon Jeruk Raya No. 27, Jakarta Barat 11530 Indonesia
Published online: 28 March 2014
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 relational operator combined with top operator. The experimental shows that using relational operator combined with indexing strategy in sub query has greater performance compared with using same method without indexing strategy and also other methods. In summary, for application that emphasized on the performance of retrieving data from database, it better to use relational operator combined with indexing strategy. This study is done on Microsoft SQL Server 2012.
Key words: Sub query / indexing / performance / SQL Server
© Owned by the authors, published by EDP Sciences, 2014
This is an Open Access article distributed under the terms of the Creative Commons Attribution License 2.0, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.