this is for holding javascript data
H.S.Bhathiya(110059X) edited section_Proposed_Solution_We_propose__.tex
about 8 years ago
Commit id: ed3f8f3c131e9dd370f429267e2cc5faaa2a7ef9
deletions | additions
diff --git a/section_Proposed_Solution_We_propose__.tex b/section_Proposed_Solution_We_propose__.tex
index 97447a7..4d68fee 100644
--- a/section_Proposed_Solution_We_propose__.tex
+++ b/section_Proposed_Solution_We_propose__.tex
...
FROM INSTRUCTOR ,TEACHES,COURSE, TAKES, STUDENT
WHERE TEACHES.COURSE_ID=COURSE.COURSE_ID AND TAKES.COURSE_ID = COURSE.COURSE_ID AND STUDENT.ID = TAKES.ID
\end{verbatim}
\begin{verbatim}
Above is normal query which results in left-deep tree on oracle
\begin{verbatim}
WITH
t1 as (SELECT /*+ no_merge */ INSTRUCTOR.ID as Instructor_ID, COURSE.COURSE_ID, COURSE.COURSE_ID as T1_ID
FROM INSTRUCTOR ,TEACHES,COURSE