PRB: ???????? ??? ?????? ???? ????????? A "LOOKUP ??????? ????????.. .WITH ??????? ??????" ?????? ?????? ????????? ????

?????? ????????? ?????? ?????????
???? ???????: 260652 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

??? ??? ?????? ???? ?????? ??? ???? Nested ? ??? ??????? ?????? ???? ?????? ???? WITH ??????? ?????? ??? ????? ?? ??????? ???? ?????? ???? ????????? ????? ???????? ???????? ????. ??? ??????? ??????? ???????? ????? ?????? ???? ??????? ??? ??? ???????? ?? ?????? ?????? ??????? ?? ??? ????? ???????. ?? ???? ??? ?????? ??? ??? ?????? ?????? ????? ?????? (spids).

???? ??????

??? ??? ?????? ????? ????? ?? LOOP ??????? ?? ??? ?? ???? ???.

??????? ????

???? ?? ??? ????? ??? ?????? ???????? ?????? ??????:
SELECT c.mstr_acct, c.last_name_m, c.first_name, c.name_prefix, c.company_name
FROM tickler a 
 INNER LOOP JOIN member b    ON a.mbr_acct = b.mbr_acct 
 INNER LOOP JOIN person c    ON b.mstr_acct = c.mstr_acct 
WHERE a.tickler_code = 'SPIRITEXT' 
				
SHOWPLAN ??????? ?? ???? ????????? ??????:
StmtText                                                                                                                                            
---------------------------------------------------------------------------------------------------------------------------------------------
  |--Bookmark Lookup(BOOKMARK:([Bmk1002]), OBJECT:([TestLoopJoin].[dbo].[person] AS [c]) WITH PREFETCH)
       |--Nested Loops(Inner Join)
            |--Nested Loops(Inner Join)
            |    |--Index Seek(OBJECT:([TestLoopJoin].[dbo].[tickler].[tickler_code] AS [a]), SEEK:([a].[tickler_code]='SPIRITEXT') ORDERED)
            |    |--Clustered Index Seek(OBJECT:([TestLoopJoin].[dbo].[member].[pk_member] AS [b]), SEEK:([b].[mbr_acct]=[a].[mbr_acct])  ORDERED)
            |--Index Seek(OBJECT:([TestLoopJoin].[dbo].[person].[pk_person] AS [c]), SEEK:([c].[mstr_acct]=[b].[mstr_acct]) ORDERED)
				
??? ?????? ?? ???? ????? ?????? ?? ???? ??? ????? ??? ????? UPDATE ??? ??? ?????? ?????? ??? ?????? ?? ??????. ??? ???? ??? ?? UPDATE ??? ??? ?????? ???? ?????? ????? ??????? ???????? ?????? ????? SELECT ?????? ???? ??? ??????? ??? ??????. ??? ??????? ????????

??????? ???? ????? ??? Bookmark ???????? ???????? ????? ?????? (???? ?? ?? ????? ???????) ????? ?? ?????? ???????? ?? ???? ?? ???? ?????? ????????. ????? ?????? ????? ????? ??????? ???????? ???????? ?? ????? ?? ???? ?? ???? ?? ???? ?????? ????????. ????? ?????? ????? ????? ??? ???? ?? ???? ?????? ???????? ???? ??? ????? ?? ???? ????. ??? ??? ???? WITH ??????? ?????? "?? ?????? ????? ?? ????? ????????? ???? ??? ?????? ??????? ??? ?????? prefetching (???????- ?????) ??? ????? ?? ?????? ?????? ?? ???? ?? ???? ?????? ????????.

???????

???? ???????: 260652 - ????? ??? ??????: 21/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbpending kbprb KB260652 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????260652

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com