Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Designing a database

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.