8 Comments
User's avatar
Ivan H's avatar

Could you also write about NoSQL specifically MongoDB?

Expand full comment
Andy Miles's avatar

Thanks for writing such a clear article. I shared it with all my clients.

Expand full comment
Mihailo Joksimovic's avatar

This is really great article

Expand full comment
Loïc's avatar

You also have tons of tutorials on https://livesql.oracle.com/

Expand full comment
Norayr Ghukasyan's avatar

Great Article.

Expand full comment
GAURAV KUMAR's avatar

is it possible for query optimizer to chose sub optimal plan which can cause performance degradation. This happened in one of the environment and still i couldn't get the idea behind it

Expand full comment
Anonymouseee's avatar

Thank you for this good sir!

Expand full comment
Esraa's avatar

what is the idea behind avoiding SELECT DISTINCT where possible?

Expand full comment