Performance Comparison of Common Table Expressions and Cursors
Journal Title: International Journal on Computer Science and Engineering - Year 2012, Vol 4, Issue 7
Abstract
This paper compares the performance of common table expressions and cursors when implemented for complex queries. Cursor enables traversal of records in a database. Cursors can also be called as “Iterators”, as it performs retrieval, addition and removal of database records based on the given condition. It is mainly used for processing individual rows in a database. Common table expression is an alternative for derived tables. It increases the performance and reduces the complexity of the queries. CTE is mainly used for writing recursive queries.
Authors and Affiliations
Sowndarya. S , Sridhar. A
Keywords
Related Articles
- EP ID EP119709
- DOI -
- Views 123
- Downloads 0
Design Of An Automatic Speaker Recognition System Using MFCC, Vector Quantization And LBG Algorithm
The results of a case study carried out while developing an automatic speaker recognition system are presented in this paper. The Vector Quantization (VQ) approach is used for mapping vectors from a large vector space to...
A Novel Technique for Embedding Data in Spatial Domain
Abstract- Steganography is the science of hiding messages in a manner that only the intended users knows the presence of the secret message. Hiding the information within a computer file also comes under Steganography. I...
A Comparative Study of Public Key Cryptosystem based on ECC and RSA
The paper gives an introduction to the public key cryptography and its use in applications such as Key Agreement, Data Encryption and Digital Signature. The main emphasize is on some public key algorithms such as RSA and...
RISK BASED TESTING A Fuzzy Approach
Earlier Testers used to concentrate on only functionality, usability or performance sort of testing. Many of these derived by the customer’s desire or need. Same thing was with the risk based testing. If an application u...
REVIEW of SOME MINIMUM-PROCESS SYNCHRONOUS CHECKPOINTING SCHEMES for MOBILE DISTRIBUTED SYSTEMS
The term Distributed Systems is used to describe a system with the following characteristics: i) it consists of several computers that do not share memory or a clock, ii) the computers ommunicate with each other by exch...