{"product_id":"kumar-mishra-sambit-performance-evaluation-and-optimization-of-queries-in-multi-databases-9783330079267","title":"Performance Evaluation and Optimization of Queries in Multi Databases","description":"Modern database systems use a query optimizer to identify query plan to execute declarative SQL queries. Optimization is a mandatory exercise since the difference between the cost of the best plan and a random choice could be in orders of magnitude. The role of query optimizers is especially critical for the decision-support queries featured in data warehousing and data mining applications. For a query on a given database and system configuration, the optimizer's plan choice is primarily a function of the selectivities of the base relations participating in the query. In this chapter, it has been projected towards the cost of sub-query operations on the various sites, as well as the benefits achieved in the range of thirty to forty percent for various sub-operations like selection, projection and join.","brand":"LAP LAMBERT Academic Publishing","offers":[{"title":"Default Title","offer_id":54706385256790,"sku":null,"price":0.0,"currency_code":"EUR","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0925\/5829\/5382\/files\/product_image_9783330079267_1.jpg?v=1794726958","url":"https:\/\/www.momoxbooks.com\/products\/kumar-mishra-sambit-performance-evaluation-and-optimization-of-queries-in-multi-databases-9783330079267","provider":"momox","version":"1.0","type":"link"}