FIX: ???? ????? Suboptimal ??? UPDATE ??? ????? ??? ??? ??????

???? ???????: 286234 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???: 236137 (SHILOH_BUGS)
????? ???? | ?? ????

???????

?? ???? ????? ???? ??????? ????? ??? ?????? ?? ??? suboptimal ????? ????? ????? ????? ???????? ??? ????? ???????.
???? ??? ?????? | ????? ???????

?????

?? ??? ???? ????? ??????? ?? ??? ???? ????? ?? ???? ????? ??? ???? ????????? ??????.
???? ??? ?????? | ????? ???????

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211
(http://support.microsoft.com/kb/290211/EN-US/ )
INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000
???? ??? ?????? | ????? ???????

???? ??????

???? ??????? ??????? ????????? ?? ????? ??? ??????.
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? SQL Server 2000. ?? ????? ??? ??????? ???? ??? ?? SQL Server 2000 Service Pack 1.
???? ??? ?????? | ????? ???????

??????? ????

????? ????????? ???????? ??????? ???? ???????. ???? ????? ?????? "???? ????? ???????" ??? ????? ????. 
use tempdb
go
IF EXISTS(SELECT * FROM information_schema.views where table_name = 'v1')
  drop view v1
IF EXISTS(SELECT * FROM information_schema.tables where table_name = 't1')
  drop table t1
go

create table t1 (a int, b bigint NOT NULL)

set nocount on
declare @i int
set @i=1
while (@i<100000)
begin
  insert into t1 values (@i,0)
  set @i=@i+1
end
go

SET NUMERIC_ROUNDABORT OFF 
SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ON
GO
create view v1 (a,b,c) with schemabinding as select a, sum(b), count_big(*) from dbo.t1 group by a 
go
create unique clustered index i1 on v1(a)
go

set statistics profile on
insert into t1 values (1,1)
set statistics profile off
go
???? ??? ?????? | ????? ???????

???????

???? ???????: 286234 - ????? ??? ??????: 20/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB286234 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????286234
(http://support.microsoft.com/kb/286234/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????