Yes, indexes can help the performance of some SELECT statements, provided you have the proper indexes in place for the query optimizer to use.
To get a better understanding of how DB2 for i5/OS can utilize indexes to improve performance, I'd strongly recommending reading the Indexing & Statistics Strategy white paper online.
Dig deeper on i5-OS
Related Q&A from Kent Milligan
To monitor members stuck within a physical file on AS/400, you can periodically use the display file description (DSPFD) command to create an output ...continue reading
Create a host variable of the where in statement on the fly with dynamic SQL.continue reading
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.