Study of Query Optimization Techniques using Different Schemas: A Review

Neha Agarwal; Manisha Raina

doi:10.37591/joadms.v4i1.1004

Abstract

AbstractMining of Data is the extraction of concealed prognosticative data from vast databases or set of information, is a solid innovation with good imminent to help organizations concentrate on the most essential data in their information distribution centers. Query Optimization is a motivation behind numerous relational database management systems. The query optimizer experiments to manage the most productive approach to actualize a given question by looking at the conceivable query plans. In this paper, the diverse procedures is given for streamlining question utilizing blueprint based and emerged views in data distribution center to be specific view adjustment and synchronization, view determination and view support.Keywords: Query optimization, materialized view, SQLCite this ArticleNeha Agarwal, Manisha Raina. Study of Query Optimization Techniques using Different Schemas: A Review. Journal of Advanced Database Management & Systems. 2017; 4(1): 26–29p.