Given the schema: Customer(custId, custName, custAdd, creditLimit)
Order(orderNo, custId, date, orderTotal, deliverToName, deliverToAddress)
Assume Customer has 1000 records, 200 bytes each. It is in order by custId, and has an index on CustName with two levels. There are 950 values for custName. Order has 5000 records, each 300 bytes. It is in order by orderNo and has an index on custId with three levels. Assume page size is 4096 bytes for both files.
Give an efficient strategy for the following query and estimate its cost, using an appropriate formula:
SELECT Customer WHERE custName ='Bob Davis'