SQL Indexes - Definition, Examples, and Tips

This is really nice, would you ever consider making a more advanced version, for people who know what indexes are but need advice on where to create them, what columns to add, single vs. multi-column

Love these easy-to-digest videos to cover missing pieces of knowledge or act as refreshers!

Also, the teaching style. Thank you!

great intro video, thank you

Does order matter when choosing which columns in the WHERE clause? Say for example I have a primary key index of (ID, LOCATION). There will be many ID's in the table, but only 5 LOCATION values. In my SELECT statement, should I use "SELECT * FROM EMPLOYEES WHERE ID = :P_ID_PARM AND LOCATION = :P_LOCATION_PARM" or should I use "SELECT * FROM EMPLOYEES WHERE LOCATION = :P_LOCATION_PARM AND ID = :P_ID_PARM"? Does it matter?
Thanks!

TopNotch

Super! Many thanks for sharing!

another helpful video, thanks again

Great.......I have one question I don't know is it valid or not. Suppose I created one index on the primary key of one table, Will it run automatically, or need to create any job for that?

Thanks for the explanation. It was very very helpful. Now I really understand well indexes.

very nice explaination

Thanks for the brief Explanation, Sir.


Can you please clarify my doubt. Sir, I have created an index but the optimizer is not using it? What are Such cases where optimizer doesn't use the index?