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

View More Free Quizzes
Related BrainMass Solutions

  • Structured Query Language (SQL) Preliminaries

    Compare the join and the SQL subquery. Although join expressions can substitute for many subquery expressions, they cannot substitute for all of them. Subqueries that involve EXISTS and NOT EXISTS cannot be represented by joins.

  • SQL Management Studio Database

    *,e.* from summary as s inner join employee as e on e.employee_no=s.employee_no where s.job is null and s.promotion_no = 'P2' 5. Using a subquery, get the first and last names of the employees who work in the Orange Appeal store.

  • Explicit SQL Statement

    Hint: A JOIN should not be used; A subquery should be used instead. /*1- Provide an explicit JOIN SQL statement that returns the store ID, store name, manager employee first and last name fields, manager employee grade, the city and state fields of

  • Database, subqueries, and joins

    The commands have to be correctly applied or the join will not work. Same with the subquery. Access is a key consideration in which is chosen.

  • Comparison of two select queries

    Here's a query: SELECT orders.order_date, orders.customer_numb FROM orders INNER JOIN order_lines ON orders.order_numb = order_lines.order_numb WHERE order_lines.isbn = '0-131-4966-9'; and here it is rewritten using a subquery

  • SQL Commands

    Use a subquery. 6. Write a SQL statement to show the Warehouse and average QuantityOnHand of all items stored in a warehouse managed by 'Smith'. Use subquery. 7.

  • Subqueries and correlated queries

    The single-row subquery returns only one row for the given query. There is a scenario in single row subquery, where the query returns with one column. This type of query is called a scalar subquery.

  • Database Re-Engineering and Redesign

    What is the difference between a correlated subquery and a regular subquery? A correlated subquery appears deceptively similar to a regular subquery. The difference is that a regular subquery can be processed from the bottom up.

  • SQL Server Database

    Query 8 (SELECT SUBQUERY): Write a SELECT query that utilizes a SUBQUERY to determine if the EEO-Classification for an employee is invalid. This means that you need to use the NOT EXIST for the SUBQUERY.

View More Related Solutions