Assuming two tweets fit on a page of memory how many

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 0 records * 1KB/record) / (8 KB/page) = 2,000 pages [R][S]/100 + [R] = 2000*1500/100 + 1500 = 31,500. 8 Throughout your experience at Puppy Love you have learned some basic facts about what joins to consider. These facts are intended for non- trivial settings: i.e. B>4 pages worth of buffer space, and relations R and S of size > B. 20. Block nested loop join is ________ better than page- oriented nested loop join. [1pt] always Block nested loop join is page- oriented on steroids, and steroids are always goo...
View Full Document

Ask a homework question - tutors are online