Question 6-2 Given B+ tree indices on name, and total-credit. The height of the indices are 4 and 2 respectively. SQL: SELECT * FROM student WHERE name='Abdullah' AND total-credit 100 t = 0.1ms, ts = 10ms The number of tuples (pointers) name='Abdullah AND total-credit = 100 are 50 and 200 respectively. The number of common pointers are 5 and each tuple is in different block. a. Find the cost of the SQL using A9 algorithm. The indices are secondary index Query cost = index cost + data cost Cost = Cost of (name index + total-credit index) + 5 data b. Analyze the result Question 6-2 Given B+ tree indices on name, and total-credit. The height of the indices are 4 and 2 respectively. SQL: SELECT * FROM student WHERE name='Abdullah' AND total-credit 100 t = 0.1ms, ts = 10ms The number of tuples (pointers) name='Abdullah AND total-credit = 100 are 50 and 200 respectively. The number of common pointers are 5 and each tuple is in different block. a. Find the cost of the SQL using A9 algorithm. The indices are secondary index Query cost = index cost + data cost Cost = Cost of (name index + total-credit index) + 5 data b. Analyze the result