PPT Slide

t.cno=c.cno

c

Courses

?c.title=“DB”

Students

t.id=s.id

t

Transcripts

s

s

Previous slide

Next slide

Back to first slide

View graphic version

Here is the unnested query. Since we promoted the operators of the inner queries to the outer query, we have some new opportunities for optimization, such switching Courses with Transcripts, which makes the query more efficient.