SQL query optimization

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

I have an embedded SQL program that I have noticed a delay on the OPEN
CURSOR.  After running it through debug, i find that it is creating a
'Temporary result file' CPI4325 with reason code of '7' which says that the
optimizer decided to do a sort rather than an access path.
The file has a Key on it, in the order that i have selected on my SQL
statement.  So i thought(ok, it doesn't like the key on the physical.) SO i
created a logical file with the proper key.  I still get the same thing
happening.

Does any one have any ideas.

Why is it not using the access path of my logical?
suggesstions!!

Thanks

Mike