Estimate the i/o cost of the best possible solution

Assignment Help Computer Engineering

Reference no: EM133186572

Question: Consider a file of customer data that consists of 200,000 records, spread over 5000 disk blocks. There is a secondary index on the key attribute, customer Id with 4 levels. There is another cluster index on total amount spent by customer with 3 levels. For each of the following selection queries, estimate the I/O cost of the best possible solution, making use of the access paths available.

Justify answer with details

SELECT * FROM customer WHERE customerId= 786 OR customerId= 222;

SELECT COUNT(*) FROM customer WHERE customerId= 222 OR customerId= 786;

SELECT * FROM customer WHERE totalAmountSpent >= 75000; (Assume 6% of the customers have spent 75,000 or more)

Reference no: EM133186572

Questions Cloud

Create simple versions of the location and gamemap classes : Create simple versions of the Location and GameMap classes from the previous task. To be clear about the (small) distinction

Find the first pair by testing a key : Find the first pair by testing a key for at most n - 1 locks. Then we remove this pair and repeat the process. How many trials does this algorithm require

Design a classifier that can identify : Design a classifier that can identify which of the two factories produced a given defective PPE. Let the components of the PPE be available and measurable

What are the final clusters : what are the final clusters and which is a better grouping in terms of within-cluster variance? Justify your answer

Estimate the i/o cost of the best possible solution : Consider a file of customer data that consists of 200,000 records, spread over 5000 disk blocks. There is a secondary index on the key attribut

Generate ideas for smart traffic management system : How to represent your thoughts, for example, you may explain them in words or depict them. The primary need is that the idea be clear

Standard of conduct expected of agents : The Estate Agents (Professional Conduct) Regulations 2018 set out the standard of conduct expected of agents and agents' representatives in their day-to-day dea

Calculating a decision and overall assessment : Abdullah Alarifi, has completed his Master's in Business. Abdullah's is passionate about driving and racing car. Another hobby of Abdullah is body cooking inter

Marketing firm regarding environmental protection policies : Consider the summary of a survey conducted by a marketing firm regarding environmental protection policies among residents of two regions of the country.

User Account

All Pages