Create indexes; it’s not just the DBA’s responsibility You know your application’s intentions better than the DBA. You should know which columns will be used for lookups, which tables are read-mostly, and which are write-mostly. It’s your responsibility to come up with the first iteration of indexes.

