Internet: The query optimized will see through your cartesian join (query generator limitation) and properly left join on your filter.

Query optimizer after blowing up my laptop:

Post Photo
Posting as :
works at
You are currently posting as works at


Related Posts

Anyone has any idea about EY Audit-Consulting split and how it would impact employees? EY


Vendor asked for closed caption files for a vid, but before sending I wanted to confirm where the vid would be to need them (for usage rights). He proceeded to then explain how captioning works.


Hi.. can someone please tell me salary for a Senior consultant 3 at EY London in Supply Chain consulting? I work in India right now for PwC. Do they benchmark based on current salary?


How much TTC does SAP Labs offer for T1 L3?


My work efficiency today is like 20 percent and dropping by the hour. Dont know why but the ole thinker just is not booting up this afternoon.


Alright everyone, if your company is hiring let’s get that referral link or if you know a coming is hiring post it while the market is hot 🔥 happy end of Q3! 🚀


Small High West tasting. My ranking Bourye 15, Midwinter Night’s Dram Act 9 Scene 3, Double Rye Houston Babe Society and Rendezvous.

Post Photo

KPMG global v/s J.P Morgan which is the best in your opinion for a 4.2 years experience?


What RFE did you receive and how long did it take to prepare a response?

Hi Fishes,
I recently joined Pwc AC and was informed to update my checkpoint portfolio where we update all our investments. If we have some investments and if we do not declare, will it be a problem or can I update it as Nothing to report. Recently I joined here so I'm having some confusion regarding this.


MBA? What to do with it? How have you used your MBA?


Recommendations please for hair cut (female) in lower Manhattan?


Has anyone worked with I’ve gotten set up but before I grab a gig I just want to see what others thought.

Hello Everyone, i am working as a contractor with ZS and now i wanted to come to zs office. Will ZS reimburse all my expenses including travel and stay for a month.

Anyone work w a realtor in the FiDi / Battery Park area they’d recommend?


Please help to me to get 12 likes. Thnks


Anyone got recommendations for a good Xbox racing game? Or something Super Mario-esque?


Favorite Non-Fiction captivating podcast?


Additional Posts in Data & Analytics Consultants

Hardest interview questions you've encountered?


Just recently got accepted into UVA’s Masters in Business Analytics program and their guidance for computers doesn’t seem very helpful. Will be working with a variety of software, notably Jupiter notebook and Python, so want to make sure my computer can handle this. Currently have a 2015 MacBook Pro with 8gb of Ram, open to hearing if this will be sufficient or if I’ll need to upgrade and if so will be open to computer suggestions.


What is the maximum expectation for a Deloitte 3rd year senior consultant salary in NYC within the AML Analytics practice?


Does anyone else dream about coding if you work too late in the night, or just me?

What are your thoughts on business rule engine systems like Apache Drools for data analysis? I love the idea that if I can set it up right, business users can configure exception reporting themselves without writing any code. But I haven’t seen a strong uptake in the market, so I’m guessing there must be some issues.


GitHub finally has an official dark mode. I can now die in peace 👀🩸


Working in a boutique data analytics firm on L visa. Seeking a career change and visa sponsorship into big tech companies. Not sure what role would be more suitable for my profile. Any guidance? If you feel profile a fit for your team. Let’s connect.

Profile snapshot:
YOE : 8+, 70% BI projects, 30% ML
Tech Skills: Tableau, SQL, Python , R , ETLs, Machine learning, Excel, PowerPoint, SparkSQL, DataBricks.
Additional: Consulting , problem solving, stake holder management, project management


Any recommendations for data analytics bootcamps?


Hey Analytics Folks! Do any of you use JMP Pro? Need to understand if it’s a good tool to learn or should I invest my time in something more relevant. The intent is to learn and apply data mining...

Best way to pass az 304 exam in a week?


What is EY’s interview process like for Data&Analytics roles?


I got an offer from Hotstar strategy team, Want to discuss more about the team and the role if anyone is workinh in hotstar here


Is there any infosys consultant here?

Have an interview with amazon soon. Any tips?

For people involved with infra on cloud, how the distribution looks like across IaaS, Container Orchestration Platforms and PaaS? Just curious about adoption across industries.


Has your workload as data people gone up or down with WFH? I've got more to do now...


Gobble gobble, data people, hit me with some Thanksgiving stats to flex at dinner 🦃


Any UK based data/business analysts here? What are your salaries looking like and YOE? It seems like people in data make way more in the US …


Book recommendations for Experimentation (for a noob)


New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here


Embed this post

Copy and paste embed code on your site


Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or