In-class exercise 12 - Query Optimization QI. Given the following ovaluation plan as shown in Figure 1. Tahle Student oc

[answerhappygod]

In Class Exercise 12 Query Optimization Qi Given The Following Ovaluation Plan As Shown In Figure 1 Tahle Student Oc 1 (48.62 KiB) Viewed 70 times

In-class exercise 12 - Query Optimization QI. Given the following ovaluation plan as shown in Figure 1. Tahle Student occupier Soopager and cach page contains so maples and cach miple contains SO bytes. Tahlc Take occupies 1000 pages and cach page has 100 ruples and cach tuple occupies 40 bytes. In addition, there are 200 courses in tablo Take The age of Table Snident is uniformly distributed from 1 to 40, i.c., there are the same number of students at each age. TT (On-the-fly sname 9 (On-the-fly) cid=231 (Simple-Nested Isid=S.sid. Loop Join) (Write to temp S1) Oage > 20- Take T (File Scan Student S (File Scan) Tigure 1. Evaluation plan ttttt Please calculate the evaluation cost of this plan.-