![]() |
Optimizer Overrides
|
Reference Manual |
joinOrderFunctionAllows you to override the optimizer's choice of join order for two tables. When you use the value FIXED, the optimizer chooses the order of tables as they appear in the FROM clause as the join order. SyntaxjoinOrder = { FIXED | UNFIXED } FIXED means the optimizer should use the order of items as they appear in the FROM clause in the statement; UNFIXED (which is the default) allows the optimizer to make its own choice about join order. The words FIXED and UNFIXED are case-insensitive. DefaultExample
SELECT * Scope |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |