Quiz: Query Optimization _ Consider the relations r1( A, B, C), r2(C, D, E ), and r3( E , F), with primary keys A, C, and E, respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples, and r3 has 750 tuples. Estimate the size of r1 ⋈ r2 ⋈ r3, and gi
Quiz: Query Optimization _ Consider the relations r1( A, B, C), r2(C, D, E ), and r3( E , F), with primary keys A, C, and E, respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples, and r3 has 750 tuples. Estimate the size of r1 ⋈ r2 ⋈ r3, and give an efficient plan for computing the join.
Escuela, estudio y materia
- Institución
- Query Optimization _ Consider the relations
- Grado
- Query Optimization _ Consider the relations
Información del documento
- Subido en
- 13 de abril de 2023
- Número de páginas
- 3
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
Temas
-
with primary keys a
-
and e
-
r2 has 1500 tuples
-
and r3 ha
-
quiz query optimization consider the relations r1 a
-
b
-
c
-
r2c
-
d
-
e
-
and r3 e
-
f
-
c
-
respectively assume that r1 has 1000 tuples