Index Choices
Q1: non-clustered index on player id
Q2: clustered index on player pos
Q3: index won’t help without harming Q2
Q4, Q5: clustered index on team (tname, city)
Q6: clustered index on rink capacity
U1: team (tname, city) index will help, as will lack of indices on wins, losses, tie attributes