When designing a database file, there are 2 alternatives:
1. To design it first without any key, and then to create an access path over it.
2. To design it first with a key, and if necessary add additional access paths over it.
I've used both techniques and both give me whatever I need. But is there one which is better than the other?
When creating access paths over a file the time when it is built does not matter.
The question I have for you is how are you building your indices? Do you use CRTLF to compile a DDS, or CREATE INDEX in SQL? I would recommend that you use CREATE INDEX because the internal structure can improve performance of queries run over the file.
Dig Deeper on iSeries system performance and monitoring
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.