InterviewSolution
Saved Bookmarks
| 1. |
Consider the tables R (A, B, C), T(D,E,F), S(G, H) and U(A,D, G, I)where A, D and G inU are foreign keys referring to the primary keys with the same names.Show aninitialquery tree for the following query and optimize it using the rules ofheuristics:select B, E, G, H, Ifrom R, T, S, Uwhere R.A = U.Aand T.D = U.D and S. G = U.Gand RC = 'TEXT' and U.I > 20 and T.E = 25 |
|
Answer» Explanation: kkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkk kkkkkkkkkkkkkkkkkkkkkkkkk you are not the |
|