Комментарии:
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?