Depending on whether or not the retrieve first n records facility is used to accelerate retrieval processing, the SQL optimization method may select an access path that differs from the ORDER BY processing method. For details about the ORDER BY processing method, see the pdvwopt description in the manual HiRDB Version 8 Command Reference.