Multiple choice technology databases

Which of the following degrades the performance of database?

  1. Equi Join

  2. Outer Join

  3. Non-Equi Join

  4. Cartesian Join
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Cartesian Join (Cross Join) produces every possible combination of rows from both tables - if Table A has 100 rows and Table B has 1000 rows, the result is 100,000 rows. This exponential growth creates massive memory and CPU overhead. Equi Join, Outer Join, and Non-Equi Join all use join conditions to limit the result set, making them far more efficient than Cartesian products.

Keep practicing — related questions