Adaptive Server may not take into account column statistics for a non-optimizable in clause, which can cause it to select a sub-optimal plan for a query with in or or clauses that join multiple tables.
Start Adaptive Server with trace flag -T301 to use column statistics.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
