Resolved: Alternative solution
I just wanted to check if my alternative solution is also valid. It produced similar results as the attached solution. Is the 365 attached solution the "most correct" way to do this? If so, why? I know a few of the videos mention optimization, could my code be less efficient on a larger scale/table?
2 answers ( 1 marked as helpful)
Hi Zach!
Thanks for reaching out.
Yes, your solution is valid. It depends on some factors like created indexes and the number of records. But for this DB your solution is optimized.
Hope this helps.
Best,
Tsvetelin
You mean, it would be faster to run through the dept_manager table since it has less entries thus more optimal?
(I had the same solution as Zachary)