Summary information |
|
|---|---|
Default value |
allows_mix |
Range of values |
allrows_oltp, allrows_dss |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
Configuration group |
Query Tuning |
Optimization goals are a convenient way of matching the user’s query demands with the best optimization techniques, ensuring optimal use of the optimizer's time and resources. Adaptive Server allows users to configure for two optimization goals, which you can specify at three tiers: server level, session level, and query level.
The server-level optimization goal is overridden at the session level, which is overridden at the query level.
These optimization goals allow you to choose an optimization strategy that best fits your query environment:
allrows_oltp – the most useful goal for purely OLTP queries.
allrows_dss – the most useful goal for operational DSS queries of medium-to-high complexity.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
