H.S.Bhathiya(110059X) edited section_Proposed_Solution_We_propose__.tex  about 8 years ago

Commit id: d1717e60dca3c9ae0e82a2429179b8b11f48a933

deletions | additions      

       

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}  Now we force to build bushy tree by breaking down the queries to two sub queries. While sub queries result in left deep-trees  \begin{verbatim}  WITH  t1 as (SELECT /*+ no_merge */ INSTRUCTOR.ID as Instructor_ID, COURSE.COURSE_ID, COURSE.COURSE_ID as T1_ID