Analysis of various Query Optimization Techniques

Database Query Optimisation has emerged as the most significant factor in today's world of computing. Applications as diverse as weather satellite feedback to military operation details employ huge databases that store graphics images, texts and other formats of data. The primary challenge in maintaining this information is to access them in an efficient manner. Database optimization techniques have been derived to address this issue that may otherwise limit the performance of a database to an extent of vulnerability. In this paper we therefore discuss the aspects of performance optimization related to data access in transactional databases. Furthermore, we analyse the effect of these optimization techniques.