Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unknown statement
Message
 
 
To
12/04/2007 04:40:26
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01214861
Message ID:
01214911
Views:
8
It's internal SQL Server query releated to index statistics.

>When I run the statement in SQL Analzyer
>delete from tmp_pl_acctinfo where jobperiod = "200701"
>I saw the unknow process in the trace window.
>what it?
>
>SELECT statman([JobPeriod],@PSTATMAN) FROM (SELECT TOP 100 PERCENT [JobPeriod] FROM [dbo].[tmp_pl_acctinfo] WITH(READUNCOMMITTED,SAMPLE 4.296323e+000 PERCENT) ORDER BY [JobPeriod]) AS _MS_UPDSTATS_TBL OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1)
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform