> the questions seem pretty easy for anyone who has dealt with trying to create useful indexes in different databases and debugged slow running queries on an index.

"Should be obvious to the most dim-witted individual..." https://www.youtube.com/watch?v=j4F8jfeLog4