An Approach for Query Optimization by using Schema Object Base View

Mining of Data is the extraction of hidden prognosticative information from large databases or set of data, is a strong new technology with great prospective to help companies focus on the most important information in their data base. Query optimization is a purpose of many relational database management systems. The query optimizer experiments to dictate the most efficient way to implement a given query by examining the possible query plans. There are different techniques is given for optimizing query using schema based and materialized views in data base namely- Query Graph, Tableaus, Optimization of Queries having Aggregates. In this paper we are using Different query optimization parameter and create an effective approach by using this approach we are reduce query execution cost, query space and mor