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 108
- Downloads 0
A Framework for Incremental Hidden Web Crawler
Hidden Web’s broad and relevant coverage of dynamic and igh quality contents coupled with the high change frequency f web pages poses a challenge for aintaining and fetching p-to-date information. For the purpose, it...
Molecular Database Generation for Type 2 Diabetes using Computational Science-Bioinformatics' Tools
In this paper a new algorithm GIGC is proposed which is the modified form of glucose insulin meal GIM model. Diabetes mellitus is one of the worst diseases that are affecting adversely large population. This motivates ma...
Role of IPv6 over Fibre (FIPv6): Issues and Challenges.
Deploying the next generation Internet protocol (IPv6) over Fibre is facing an important challenge as the Fibre standard is failing to support IPv6 functionalities. In fact unlike the other tandards Fibre optic links is...
IMPROVED HYBRID MODEL FOR DENOISING POISSON CORRUPTED XRAY IMAGES
Medical practitioners are increasingly using digital images during disease diagnosis. Several state-of-the-art medical equipments are producing images of different organs, which are used during various stages of analysis...
A NOVEL CODEBOOK INITIALISATION TECHNIQUE FOR GENERALIZED LLOYD ALGORITHM USING CLUSTER DENSITY
In this paper, a novel codebook initialization technique has been adopted for Generalized Lloyd Algorithm (GLA). GLA plays an important role in the design of Vector Quantizers. The proposed technique generates initial se...