How efficiently does iSeries DB2 use index with WHERE ?
Using System i Navigator, you can run your queries in there to see if there are more indexes that may be recommended. The system tries it best to create the right indexes before running and caches those access paths. 

One thing I did in my last project with some larger queries was to create procedures. Then the system stores those access paths and speeds up your queries even more.