Purchase Solution

Subquery vs. Join.

Not what you're looking for?

Ask Custom Question

Please help me with this question:
Which is better to use, a subquery or a JOIN? Why?
Show an example of each to support your reasoning.
Communicate with a relational database to create tables, and query and manipulate data.
Use normalizing and data integrity methodologies when designing a database.
Create and manage databases and their related components.

Purchase this Solution

Solution Summary

This solution compares sub-query with JOIN, and provides an example of each database system to support the assessment.

Solution Preview

** Please see the attached file for Word formatted version of the solution **

There are ongoing arguments among experts about the superiority of sub-query vs JOIN. Both sides have their reasons to support their position. From my point of view, there are several axis of being "better":
- better performance
- better readability
- better maintainability
- better flexibility and so on

In JOINs RDBMS can create an execution plan that is better for our query and can predict what data should be loaded to be processed and save time, unlike the ...

Purchase this Solution

Free BrainMass Quizzes
Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media