Under pipelined execution, what would be the IO cost of the query below if we only...

 

Transcribed Image Text:

Under pipelined execution, what would be the IO cost of the query below if we only used the block-at-a-time nested join algorithm? What would be the 10 cost under blocking execution? SELECT R.a, S.b, T.c FROM R, S, T Write your answers as equations. Use B(R), B(S), B(T) as the number of pages/blocks; T(R), T(S), T(T) as the number of tuples in the respective table. Assume the join tree ((R JOIN S) JOIN T). Pipelined execution cost: Enter your answer here Blocking execution cost: Enter your answer here Under pipelined execution, what would be the IO cost of the query below if we only used the block-at-a-time nested join algorithm? What would be the 10 cost under blocking execution? SELECT R.a, S.b, T.c FROM R, S, T Write your answers as equations. Use B(R), B(S), B(T) as the number of pages/blocks; T(R), T(S), T(T) as the number of tuples in the respective table. Assume the join tree ((R JOIN S) JOIN T). Pipelined execution cost: Enter your answer here Blocking execution cost: Enter your answer here

Answer rating: 100% (QA)

Answer Number of pipeline stagesk 6 clock cycle time 4 ns a Given Number of in... View the full answer