Database PERFORMANCE Made SUPER SIMPLE - Part 1

[@CodeItUpByAMBITIONED]

PROTIP: Watch me at 1.5x speed to save time! 😎 Do you love this video about database indexes? What is your opinion about it? 🙄 What kind of lessons do you prefer? Shorter or longer? Let me know in the comments! 👇 You can get my source code from here: bit.ly/my-source-ciu 👈

[@xelaksal6690]

Thank you for your effort! Good examples.

[@KrisLyubenov]

Always easy to understand and detailed explanation. Thanks Ivo!

[@CodeItUpByAMBITIONED]

Thank you very much!

[@vasil922]

If you need to sort your query results in the end by many columns, is it beneficial to add a non-clustered index on all applicable columns based on their sort order (some may be asc, some desc)? I feel like sometimes that would be an overkill if say you don't have that many duplicates past the first (most significant) column for which you can often reuse an existing index.

[@CodeItUpByAMBITIONED]

Thank you for your comment. It depends on the scenario. You should always measure all options and consider them afterwards.