I don't know how to get a query plan, can you explain how, thank you!
It's a database specific question, and I don't know anything about AS400 databases, so, no. You'd have to talk to your database guys or read the database documentation. Though you could answer the other questions and figure out (guess) for yourself whether or not an index might be worthwhile.