In this example, the IBM database monitor is not recommending an index. It would show as "Scan: 1" indicating that a table scan occurred and that an index will help. Even though IBM is not recommending one, I will if one doesn't already exist over the F9861 physical file keyed by the 3 fields in the WHERE clause. You need to make sure that it doesn't already exist using option 15 from the EZRAD WORKPERF menu. Also, the Query Optimizer summary data will help you determine how often this SQL request ran. This one request took a fraction of a second. If it only ran once, don't build any indexes for it. If it runs 50,000 times an hour, build one.