Mastercard Interview Question | Solution
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways
Answers ( 2 )
Set-based solutions provide better performance as they work on a result set and not on one row at a time. They are concise and more readable.
When you are processing huge amounts of data, set based query will generally
make use of multiple threads of the database engine and process it faster, whereas
cursor will generally go sequentially and make use of single thread.