In pre-12.5.2 versions of Adaptive Server, queries that used update and delete on views with a union all clause were sometimes resolved without using worktables, which occasionally lead to incorrect results. In Adaptive Server 12.5.2, queries that use update and delete on views with a union all clause are always resolved using worktables in tempdb. However, this behavior may result in a performance degradation.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
