Basic concepts of database performance tuning should be a must for a competent database developer.

A specific task to accomplish in this respect would be to understand the query's estimated execution plan.