If you have created the right indexes, the Sybase IQ query optimizer can usually execute queries in the most efficient way — sometimes even if you have not used the most effective syntax. Proper query design is still important, however. When you plan your queries carefully, you can have a major impact on the speed and appropriateness of results.
Before it executes any query, the Sybase IQ query optimizer creates a query plan. Sybase IQ helps you evaluate queries by letting you examine and influence the query plan, using the options described in the sections that follow. For details of how to specify these options, see Reference: Statements and Options.
For
all database options that accept integer values, Sybase IQ truncates any
decimal option-value setting to an integer
value. For example, the value 3.8 is truncated to 3.
