Q: The AS/400 SQL optimizer sometimes uses an access path when I do SQL queries. I think it would be faster to sort the records directly, after selecting them. Is there a way to get AS/400 SQL to do this?

A: Apply PTF SF27499 for V3R1, which gives the SQL optimizer permission to do a sort when necessary. The product code for this PTF is 5763SS1. This may speed up your queries when you are selecting just a few records out of a large table.

- Brian Singleton