contestada

Consider a scenario, there are three tables name ‘X’, ‘Y ‘and’ Z’ with schemes X (u, v, w), Y (l, u, m, n, o, p) and Z (r, s, t, u, q), These tables have a common attribute or field. We want to retrieve the data from these tables.

In this scenario, discuss which join operation can help to retrieve the records from multiple tables.
Justify your answer with at least two solid arguments.

Respuesta :

Answer:

I prefer to useINNER JOIN for this type of scenario its logical arguments are as follows:

The INNER JOINSelects all rows from all participating tables as long as there is a match between the columns.

INNER JOIN is for clarity. Using Where as in your second example can get lost in more complex queries, making it difficult to determine how your tables are joined and make it more difficult to troubleshoot problems.

INNER JOIN is faster to pull more rows.

JOIN works by concentrating the operation on the result of the first all tables, any subsequent joins would concentrate joining on the in memory result of the first joined tables and so on less read write needle movement, thus faster.

Explanation:

The operation that's more applicable will be to use INNER JOIN for this type of scenario.

Importance of the operation

In this case, there are scenario, there are three tables name ‘X’, ‘Y ‘and’ Z’ with scheme.

It should be noted that The INNER JOIN selects all rows from all participating tables she there is a match. The INNER JOIN is for clarity and faster.

Learn more about operations on:

https://brainly.com/question/24606703