The SQL language is designed to define requests for data manipulation, and to specify the final representation of results, but by design it does not support the definition of how the request should be handled by the database system. It’s up to database system to decide the best (i.e. fastest) method.

Read more: http://www.ibphoenix.com/resources/documents/how_to/doc_399