FIX: A scan of each partition table may be performed when you run an UPDATE statement on the partitioning column of a partitioned view

This article has been archived. It is offered "as is" and will no longer be updated.

BUG #: 363745 (SHILOH_BUGS)

SYMPTOMS

If you run an UPDATE statement on the partitioning column of a partitioned view and the UPDATE statement includes an inner join to another table, a scan of each partition table may be performed. This problem occurs although a useful index exists on each table. Depending on the size of each partition table, this can have a negative, and sometimes severe, effect on performance.

This problem only occurs when all the following conditions are true:

You are updating a partitioned view.

The partitioning column is included in the list of column names that are to be updated.

The UPDATE statement includes an inner join to another table.

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

Hotfix information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.