BOX8 | SQL Query
Question
TheDataMonk
Follow Me
About TheDataMonkGrand Master
I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)Follow Me
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answers ( 4 )
Cartesian Join
In my perspective cartesian join should take maximum processing time
as it always multiplies the no of rows in both the tables to get the final output.
Suppose, table 1 has 10 rows and table 2 has 20 rows, with 5 rows common.
Cartesian join will give 10*20 = 200 rows.
Full outer join will give (10 + 20 – 5) = 25 rows(Left outer + Right Outer – inner).
Left outer join will give 10 and Right Outer will give 20 rows.
This is a scenario when you are generally matching on some columns which
are acting as primary key or have unique values.
If all the values in the columns which you are matching are same, then probably,they
would all take the same time as they would produce the same output.
Cartesian Join as it is a cross product
Cartesian Join will take more time , it is a cross product of two columns.