Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unknown statement
Message
 
 
À
12/04/2007 04:40:26
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
01214861
Message ID:
01214911
Vues:
9
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform