Re: I can't think of the subject name (have not words).

David Williams <djw@smooth1.demon.co.uk> offerred: +>+OPTCOMPIND 0 +>+OPT_GOAL 0 + + What is OPT_GOAL ??? It is both a config parameter (in $ONCONFIG) and environment variable. Setting it to -1 is the default behavior (ALL_ROWS). Setting it to 0 (FIRST ROWS) means the optimizer will come up with an access strategy that will result in the first row getting returned to the user as quickly as possible, even if that strategy results in the query in its entirety taking longer. The default behavior is to optimize for overall query performance. For more details, see Art's excellent posts on the same subject detailing how these different strategy can manifest on queries. Dave -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)