Performance Evaluation and Optimization of Queries in Multi Databases
% SALE
Performance Evaluation and Optimization of Queries in Multi Databases
% SALE
% SALE
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.
Product details
- Type:
- Book
- Binding:
- Paperback
- Languages:
-
Original:
English
- Number of Pages:
-
52
- Publisher:
-
LAP LAMBERT Academic Publishing
- Publication Date:
-
2017-04-26
- ISBN / EAN:
-
9783330079267
- Weight:
-
96 g
- Dimensions:
-
15/22/0 cm
- GPSR Manufacturer Reference:
-
[email protected]
Die gelieferte Auflage kann ggf. abweichen.
Currently sold out
Back in stock email
Add to Wishlist