You can directly specify the abstract plan for a query by:
Using the create plan command
Adding the plan clause to select, insert...select, update, delete and return commands, and to if and while clauses
For information on writing plans, see Chapter 15, “Abstract Query Plan Guide.”