How to set up scheduled gather statistics jobs for Microsoft SQL Server to run on a weekly basis?

  • Published2019-11-06

Description

  • How to set up scheduled gather statistics jobs for Microsoft SQL Server (MS SQL) to run on a weekly basis?

  • According to PTC:s recommendation gather statistics should be executed weekly to keep up performance for MS SQL server

  • Gather statistics should be executed during non-working hours

  • Set up a scheduled job on the MS SQL database server to run this automatically on a weekly basis, in this case on sundays when nobody is working

  1. Start MS SQL Server Management Studios on the database server, log on as SA-user

  2. Right click on SQL Server Agent --> New --> Job...

  3. Set a name to the job and go to Steps

  4. From Steps press New, set name and choose database instance in this case pdmlink, add the database command (found below) then press OK:


    Database command for gather statistics, copy/paste into the Command-prompt:

    update statistics pdmlink.AbsCollectionCriteriaKey with fullscan;
    update statistics pdmlink.AbstractSite with fullscan;
    update statistics pdmlink.AcceptedStrategy with fullscan;
    update statistics pdmlink.AccessControlSurrogate with fullscan;
    update statistics pdmlink.AccessControlSurrogateMaster with fullscan;
    update statistics pdmlink.AccessPolicyRule with fullscan;
    update statistics pdmlink.actionitemnumber_seq with fullscan;
    update statistics pdmlink.ActionItemSubjectLink with fullscan;
    update statistics pdmlink.ActionPullItem with fullscan;
    update statistics pdmlink.ActionShippingItem with fullscan;
    update statistics pdmlink.ActiveViewLink with fullscan;
    update statistics pdmlink.ActivityActivityLink with fullscan;
    update statistics pdmlink.ActivityAssignmentLink with fullscan;
    update statistics pdmlink.ActivityConnectorLink with fullscan;
    update statistics pdmlink.AddressedBy2 with fullscan;
    update statistics pdmlink.AddressesDirective with fullscan;
    update statistics pdmlink.AdHocAclLink with fullscan;
    update statistics pdmlink.AdHocAclSpec with fullscan;
    update statistics pdmlink.AdminDomainLink with fullscan;
    update statistics pdmlink.AdministrativeDomain with fullscan;
    update statistics pdmlink.AdvancedFindCriteria with fullscan;
    update statistics pdmlink.AffectedActivityData with fullscan;
    update statistics pdmlink.AgendaDocumentLink with fullscan;
    update statistics pdmlink.Aggregate with fullscan;
    update statistics pdmlink.AggToContentItem with fullscan;
    update statistics pdmlink.AgreementAuthorizedObject with fullscan;
    update statistics pdmlink.AgreementAuthorizedProxy with fullscan;
    update statistics pdmlink.AGREEMENTID_Seq with fullscan;
    update statistics pdmlink.AgreementPrincipalLink with fullscan;
    update statistics pdmlink.AlertItem with fullscan;
    update statistics pdmlink.AlternateRepContainerLink with fullscan;
    update statistics pdmlink.AlternateRepresentation with fullscan;
    update statistics pdmlink.AlternateUnitLink with fullscan;
    update statistics pdmlink.AlternateUnitOfMeasure with fullscan;
    update statistics pdmlink.AnnotationBaseline with fullscan;
    update statistics pdmlink.AnnotationSet with fullscan;
    update statistics pdmlink.AppDataToFvFractionLink with fullscan;
    update statistics pdmlink.ApplicationData with fullscan;
    update statistics pdmlink.ApplyPathFilterCriteriaLink with fullscan;
    update statistics pdmlink.Archive with fullscan;
    update statistics pdmlink.ArchivedIterationInfo with fullscan;
    update statistics pdmlink.ArchiveRecord with fullscan;
    update statistics pdmlink.AssociateDisassociateEventInfo with fullscan;
    update statistics pdmlink.AssociationRule with fullscan;
    update statistics pdmlink.associationRule_seq with fullscan;
    update statistics pdmlink.AssociationRuleMaster with fullscan;
    update statistics pdmlink.ATOChoice with fullscan;
    update statistics pdmlink.ATOChoiceMaster with fullscan;
    update statistics pdmlink.ATOGroup with fullscan;
    update statistics pdmlink.ATONavigationFilter with fullscan;
    update statistics pdmlink.ATOOption2 with fullscan;
    update statistics pdmlink.ATOOption2Master with fullscan;
    update statistics pdmlink.ATORuleConfigSpec with fullscan;
    update statistics pdmlink.AttrCriterionDef with fullscan;
    update statistics pdmlink.AttrCriterionDefMaster with fullscan;
    update statistics pdmlink.AttributeMappingRecord with fullscan;
    update statistics pdmlink.AttributeOrganizer with fullscan;
    update statistics pdmlink.AttributeStructFilter with fullscan;
    update statistics pdmlink.AttributeStructFilterExpr with fullscan;
    update statistics pdmlink.AttributeStructFilterRule with fullscan;
    update statistics pdmlink.AuditPurgeHistory with fullscan;
    update statistics pdmlink.AuditRecord with fullscan;
    update statistics pdmlink.AuditReportSpec with fullscan;
    update statistics pdmlink.AuthorizationAgreement with fullscan;
    update statistics pdmlink.AuthorizationAgreementMaster with fullscan;
    update statistics pdmlink.AuthorizatnAgreementMasterKey with fullscan;
    update statistics pdmlink.AutoVaultCleanupCriteria with fullscan;
    update statistics pdmlink.BACAttTemplateDeleteRecord with fullscan;
    update statistics pdmlink.BACBaseline with fullscan;
    update statistics pdmlink.BACBaseReceivedDelivery with fullscan;
    update statistics pdmlink.bacDeliveryNumber_seq with fullscan;
    update statistics pdmlink.BACDeliveryRecord with fullscan;
    update statistics pdmlink.BACExportRecord with fullscan;
    update statistics pdmlink.BACLCTDeleteRecord with fullscan;
    update statistics pdmlink.BACOIRDeleteRecord with fullscan;
    update statistics pdmlink.BACPackage with fullscan;
    update statistics pdmlink.BACPackageMaster with fullscan;
    update statistics pdmlink.bacPackageNumber_seq with fullscan;
    update statistics pdmlink.BACPACRDeleteRecord with fullscan;
    update statistics pdmlink.BACPhaseLinkDeleteRecord with fullscan;
    update statistics pdmlink.BACReceivedDelivery with fullscan;
    update statistics pdmlink.bacReceivedDeliveryNumber_seq with fullscan;
    update statistics pdmlink.BACSpec with fullscan;
    update statistics pdmlink.BACTarget with fullscan;
    update statistics pdmlink.BACWFProxyTemplateDeleteRecord with fullscan;
    update statistics pdmlink.BACWfTemplateDeleteRecord with fullscan;
    update statistics pdmlink.BACWTGroupDeleteRecord with fullscan;
    update statistics pdmlink.Ballots with fullscan;
    update statistics pdmlink.BaseCriterionDef with fullscan;
    update statistics pdmlink.BaseCriterionDefMaster with fullscan;
    update statistics pdmlink.BaseCriterionDefMasterKey with fullscan;
    update statistics pdmlink.BaselineConfigOverride with fullscan;
    update statistics pdmlink.BaselineMember with fullscan;
    update statistics pdmlink.BiActionPullItem with fullscan;
    update statistics pdmlink.BlackBoxFilter with fullscan;
    update statistics pdmlink.Bookmark with fullscan;
    update statistics pdmlink.BooleanDefinition with fullscan;
    update statistics pdmlink.BooleanValue with fullscan;
    update statistics pdmlink.BuildHistory with fullscan;
    update statistics pdmlink.BulkIndexListEntry with fullscan;
    update statistics pdmlink.BusinessEntity with fullscan;
    update statistics pdmlink.BusinessRule with fullscan;
    update statistics pdmlink.BusinessRuleLink with fullscan;
    update statistics pdmlink.BusinessRuleSet with fullscan;
    update statistics pdmlink.Cabinet with fullscan;
    update statistics pdmlink.CacheStatistics with fullscan;
    update statistics pdmlink.CalculatedMSNEffectivity with fullscan;
    update statistics pdmlink.CalendarComponent with fullscan;
    update statistics pdmlink.CameFromUnit with fullscan;
    update statistics pdmlink.ChangeAction with fullscan;
    update statistics pdmlink.ChangeActionCandidates with fullscan;
    update statistics pdmlink.ChangeIdentityEventInfo with fullscan;
    update statistics pdmlink.ChangeIssueResource with fullscan;
    update statistics pdmlink.ChangeIssueResourceMaster with fullscan;
    update statistics pdmlink.ChangeKey with fullscan;
    update statistics pdmlink.ChangeLifecycleStateEventInfo with fullscan;
    update statistics pdmlink.ChangeOrder2Resource with fullscan;
    update statistics pdmlink.ChangeOrder2ResourceMaster with fullscan;
    update statistics pdmlink.ChangeProcessLink with fullscan;
    update statistics pdmlink.ChangeRecord2 with fullscan;
    update statistics pdmlink.ChangeReferenceLink with fullscan;
    update statistics pdmlink.ChangeRequest2Resource with fullscan;
    update statistics pdmlink.ChangeRequest2ResourceMaster with fullscan;
    update statistics pdmlink.ChangeReviewItemLink with fullscan;
    update statistics pdmlink.ChangeReviewResource with fullscan;
    update statistics pdmlink.ChangeReviewResourceMaster with fullscan;
    update statistics pdmlink.CheckInEventInfo with fullscan;
    update statistics pdmlink.CheckoutEventInfo with fullscan;
    update statistics pdmlink.CheckoutLink with fullscan;
    update statistics pdmlink.ChoiceConstraint with fullscan;
    update statistics pdmlink.ChoiceConstraintMaster with fullscan;
    update statistics pdmlink.choiceConstraintNumber_seq with fullscan;
    update statistics pdmlink.ChoiceEnable with fullscan;
    update statistics pdmlink.ChoiceEnableMaster with fullscan;
    update statistics pdmlink.choiceEnableNumber_seq with fullscan;
    update statistics pdmlink.ChoiceMappableChoiceLink with fullscan;
    update statistics pdmlink.ChoiceMapping with fullscan;
    update statistics pdmlink.ChoiceMappingMaster with fullscan;
    update statistics pdmlink.choiceMappingNumber_seq with fullscan;
    update statistics pdmlink.ChoiceMasterKey with fullscan;
    update statistics pdmlink.choiceNumber_seq with fullscan;
    update statistics pdmlink.ChoiceRule with fullscan;
    update statistics pdmlink.ChoiceRuleMaster with fullscan;
    update statistics pdmlink.choiceRuleNumber_seq with fullscan;
    update statistics pdmlink.CIEffConfigHolderLink with fullscan;
    update statistics pdmlink.ClashToClashReportLink with fullscan;
    update statistics pdmlink.ClashToIDDMasterLink with fullscan;
    update statistics pdmlink.ClassificationNavStruct with fullscan;
    update statistics pdmlink.ClassificationNode with fullscan;
    update statistics pdmlink.ClassificationStruct with fullscan;
    update statistics pdmlink.ClientCacheState with fullscan;
    update statistics pdmlink.ClientTab with fullscan;
    update statistics pdmlink.CollaborationInfo with fullscan;
    update statistics pdmlink.CollaborationSite with fullscan;
    update statistics pdmlink.CollaborationSourceInfo with fullscan;
    update statistics pdmlink.CollectionCriteria with fullscan;
    update statistics pdmlink.CollectionCriteriaCopyLink with fullscan;
    update statistics pdmlink.CollectionCriteriaMaster with fullscan;
    update statistics pdmlink.CollectionCriterionDef with fullscan;
    update statistics pdmlink.CollectionCriterionDefMaster with fullscan;
    update statistics pdmlink.CollectionOpUsesRelMapLink with fullscan;
    update statistics pdmlink.CollectorCache with fullscan;
    update statistics pdmlink.CombOccurrenceDataMaster with fullscan;
    update statistics pdmlink.CombOccurrenceDocumentation with fullscan;
    update statistics pdmlink.CombOccurrenceUserIBAs with fullscan;
    update statistics pdmlink.ComponentLink with fullscan;
    update statistics pdmlink.CompositeIndexStructureHash with fullscan;
    update statistics pdmlink.ConfigurableDescribeLink with fullscan;
    update statistics pdmlink.ConfigurableMastersLink with fullscan;
    update statistics pdmlink.ConfigurableReferenceLink with fullscan;
    update statistics pdmlink.ConfigurableRevisionLink with fullscan;
    update statistics pdmlink.ConfigurableRevLinkHistory with fullscan;
    update statistics pdmlink.ConfigurationItem with fullscan;
    update statistics pdmlink.ConfirmableShippingItem with fullscan;
    update statistics pdmlink.ConflictResolutionPair with fullscan;
    update statistics pdmlink.ConnectorActivityLink with fullscan;
    update statistics pdmlink.ConnectorConnectorLink with fullscan;
    update statistics pdmlink.ConsumptionLink with fullscan;
    update statistics pdmlink.ContainerAdapterLink with fullscan;
    update statistics pdmlink.ContainerAttributeLink with fullscan;
    update statistics pdmlink.ContainerFilter with fullscan;
    update statistics pdmlink.ContainerFilterLink with fullscan;
    update statistics pdmlink.ContainerTeam with fullscan;
    update statistics pdmlink.ContentControlContentLink with fullscan;
    update statistics pdmlink.ContentControlPrimaryLink with fullscan;
    update statistics pdmlink.ContentControlRelationLink with fullscan;
    update statistics pdmlink.ContentControlSecondaryLink with fullscan;
    update statistics pdmlink.ContentReplRecord with fullscan;
    update statistics pdmlink.ContentReplSchedule with fullscan;
    update statistics pdmlink.ContextConflictMap with fullscan;
    update statistics pdmlink.ContextInstance with fullscan;
    update statistics pdmlink.ContextLink with fullscan;
    update statistics pdmlink.ContextType with fullscan;
    update statistics pdmlink.ContReplHistory with fullscan;
    update statistics pdmlink.ControlBranch with fullscan;
    update statistics pdmlink.CopyEventInfo with fullscan;
    update statistics pdmlink.CountedHistory with fullscan;
    update statistics pdmlink.CreatorsLink with fullscan;
    update statistics pdmlink.CriteriaSupportDataLink with fullscan;
    update statistics pdmlink.Criterion with fullscan;
    update statistics pdmlink.CriterionDefValidWith with fullscan;
    update statistics pdmlink.CriterionHistory with fullscan;
    update statistics pdmlink.CriterionLink with fullscan;
    update statistics pdmlink.CriterionObject with fullscan;
    update statistics pdmlink.CSMContainerConstraint with fullscan;
    update statistics pdmlink.CSMSingleDefConstraint with fullscan;
    update statistics pdmlink.CSRFEventInfo with fullscan;
    update statistics pdmlink.CURR_CNT_TABLE with fullscan;
    update statistics pdmlink.currentcountervalue_seq with fullscan;
    update statistics pdmlink.CurrentPhaseLink with fullscan;
    update statistics pdmlink.CustomFilter with fullscan;
    update statistics pdmlink.DataFormat with fullscan;
    update statistics pdmlink.DataMonitor with fullscan;
    update statistics pdmlink.DeadlineChangeEvent with fullscan;
    update statistics pdmlink.DeadlineEvent with fullscan;
    update statistics pdmlink.DefaultAssociationConstraintIt with fullscan;
    update statistics pdmlink.DefaultBaselineLink with fullscan;
    update statistics pdmlink.DefaultChangeItemTemplate with fullscan;
    update statistics pdmlink.DefaultCriterion with fullscan;
    update statistics pdmlink.DefaultQueryForm with fullscan;
    update statistics pdmlink.DefaultWTContainerTemplate with fullscan;
    update statistics pdmlink.DeferredEventNotification with fullscan;
    update statistics pdmlink.DeletedBuildReference with fullscan;
    update statistics pdmlink.DeletedLWCTypeDefinitionSeq with fullscan;
    update statistics pdmlink.deletedtypedefinition_seq with fullscan;
    update statistics pdmlink.Deliverable with fullscan;
    update statistics pdmlink.DeliverableLink with fullscan;
    update statistics pdmlink.DeliverablesRequestInfo with fullscan;
    update statistics pdmlink.DeliveryRecord with fullscan;
    update statistics pdmlink.DeliveryRecordSequence with fullscan;
    update statistics pdmlink.DerivedFromConfigSpecLink with fullscan;
    update statistics pdmlink.DerivedFromNavCriteriaLink with fullscan;
    update statistics pdmlink.DerivedImage with fullscan;
    update statistics pdmlink.DesignationGroup with fullscan;
    update statistics pdmlink.DetailedBy with fullscan;
    update statistics pdmlink.DigestNotification with fullscan;
    update statistics pdmlink.DigestNotificationData with fullscan;
    update statistics pdmlink.DirectoryTranslationTable with fullscan;
    update statistics pdmlink.DirectQueryTarget with fullscan;
    update statistics pdmlink.disabledrule_seq with fullscan;
    update statistics pdmlink.DiscreteActionItem with fullscan;
    update statistics pdmlink.DiscussionForum with fullscan;
    update statistics pdmlink.DiscussionForumTemplate with fullscan;
    update statistics pdmlink.DiscussionPosting with fullscan;
    update statistics pdmlink.DiscussionRecipientUserLink with fullscan;
    update statistics pdmlink.DiscussionTopic with fullscan;
    update statistics pdmlink.DowngradeTaskRecord with fullscan;
    update statistics pdmlink.DowngradeUsageEventInfo with fullscan;
    update statistics pdmlink.DownloadEventInfo with fullscan;
    update statistics pdmlink.DPImplJob with fullscan;
    update statistics pdmlink.DPImplJobToESITransactionLink with fullscan;
    update statistics pdmlink.DPImplSchedule with fullscan;
    update statistics pdmlink.DTOCADMakerState with fullscan;
    update statistics pdmlink.DTODelivDependencyLink with fullscan;
    update statistics pdmlink.DTODeliverableDefinition with fullscan;
    update statistics pdmlink.DTODelivRequestTicket with fullscan;
    update statistics pdmlink.DTORequestDependencyLink with fullscan;
    update statistics pdmlink.DTOTemplDelivDefinition with fullscan;
    update statistics pdmlink.DTOVarSpecDeliverableLink with fullscan;
    update statistics pdmlink.EffChangeAudit with fullscan;
    update statistics pdmlink.EffConfigSpecGroup with fullscan;
    update statistics pdmlink.EffContextKey with fullscan;
    update statistics pdmlink.EffectivityConfigurationHolder with fullscan;
    update statistics pdmlink.ElectronicSignature with fullscan;
    update statistics pdmlink.ElementImportInfo with fullscan;
    update statistics pdmlink.EngineState with fullscan;
    update statistics pdmlink.EnterpriseData with fullscan;
    update statistics pdmlink.EnterpriseDataDocDescLink with fullscan;
    update statistics pdmlink.EnterpriseDataDocRefLink with fullscan;
    update statistics pdmlink.EnterpriseDataEPMDocDescLink with fullscan;
    update statistics pdmlink.EnterpriseDataLink with fullscan;
    update statistics pdmlink.EnterpriseDataMaster with fullscan;
    update statistics pdmlink.EnterpriseDataMasterLink with fullscan;
    update statistics pdmlink.entryNumber_seq with fullscan;
    update statistics pdmlink.EnvironmentConflict with fullscan;
    update statistics pdmlink.EPM_seq with fullscan;
    update statistics pdmlink.EPMAsStoredConfig with fullscan;
    update statistics pdmlink.EPMAsStoredMember with fullscan;
    update statistics pdmlink.EPMAuthoringAppVersion with fullscan;
    update statistics pdmlink.EPMBuildAttribute with fullscan;
    update statistics pdmlink.EPMBuildHistory with fullscan;
    update statistics pdmlink.EPMBuildRule with fullscan;
    update statistics pdmlink.EPMBUILDRULE_seq with fullscan;
    update statistics pdmlink.EPMBuildRuleAssociationLink with fullscan;
    update statistics pdmlink.EPMCADNamespace with fullscan;
    update statistics pdmlink.EPMCheckpoint with fullscan;
    update statistics pdmlink.EPMCheckpointMaster with fullscan;
    update statistics pdmlink.EPMContainedIn with fullscan;
    update statistics pdmlink.EPMDefinitionRule with fullscan;
    update statistics pdmlink.EPMDerivedRepHistory with fullscan;
    update statistics pdmlink.EPMDerivedRepRule with fullscan;
    update statistics pdmlink.EPMDERIVEDREPRULE_seq with fullscan;
    update statistics pdmlink.EPMDescribeLink with fullscan;
    update statistics pdmlink.EPMDocConfigSpec with fullscan;
    update statistics pdmlink.EPMDocument with fullscan;
    update statistics pdmlink.epmdocument_copyrule_seq with fullscan;
    update statistics pdmlink.EPMDocumentMaster with fullscan;
    update statistics pdmlink.EPMDocumentMasterKey with fullscan;
    update statistics pdmlink.EPMFamilyTableAttribute with fullscan;
    update statistics pdmlink.EPMFamilyTableCell with fullscan;
    update statistics pdmlink.EPMFamilyTableCellDep with fullscan;
    update statistics pdmlink.EPMFamilyTableFeature with fullscan;
    update statistics pdmlink.EPMFamilyTableMember with fullscan;
    update statistics pdmlink.EPMFamilyTableParameter with fullscan;
    update statistics pdmlink.EPMFamilyTableReference with fullscan;
    update statistics pdmlink.EPMFeatureDefinition with fullscan;
    update statistics pdmlink.EPMFeatureValue with fullscan;
    update statistics pdmlink.EPMIDGroup with fullscan;
    update statistics pdmlink.EPMIDSpaceRecord with fullscan;
    update statistics pdmlink.EPMInitialCheckinData with fullscan;
    update statistics pdmlink.EPMLINK_seq with fullscan;
    update statistics pdmlink.EPMMemberLink with fullscan;
    update statistics pdmlink.EPMParameterDefinition with fullscan;
    update statistics pdmlink.EPMParameterMap with fullscan;
    update statistics pdmlink.EPMParameterUnitInfo with fullscan;
    update statistics pdmlink.EPMParameterValue with fullscan;
    update statistics pdmlink.EPMReferenceLink with fullscan;
    update statistics pdmlink.EPMResultRule with fullscan;
    update statistics pdmlink.EPMResultRuleFilter with fullscan;
    update statistics pdmlink.EPMSepFamilyTable with fullscan;
    update statistics pdmlink.EPMSepFamilyTableMaster with fullscan;
    update statistics pdmlink.EPMStructAnnAddMatchingData with fullscan;
    update statistics pdmlink.EPMStructAnnotationReplaceData with fullscan;
    update statistics pdmlink.EPMStructureAnnotation with fullscan;
    update statistics pdmlink.EPMSupportingData with fullscan;
    update statistics pdmlink.EPMUpdateCounter with fullscan;
    update statistics pdmlink.EPMVariantLink with fullscan;
    update statistics pdmlink.EPMWorkspace with fullscan;
    update statistics pdmlink.EPMWorkspaceKey with fullscan;
    update statistics pdmlink.EPMWorkspaceNamespace with fullscan;
    update statistics pdmlink.EquipmentResource with fullscan;
    update statistics pdmlink.equivalenceidentifier_seq with fullscan;
    update statistics pdmlink.EquivalenceLink with fullscan;
    update statistics pdmlink.ERPMaterial with fullscan;
    update statistics pdmlink.ERPMATERIALDOCDESCRIBELINK with fullscan;
    update statistics pdmlink.ERPMATERIALDOCREFERENCELINK with fullscan;
    update statistics pdmlink.ERPMATERIALEPMDOCDESCRIBELINK with fullscan;
    update statistics pdmlink.ERPMaterialLink with fullscan;
    update statistics pdmlink.ERPMaterialSet with fullscan;
    update statistics pdmlink.ERPPartSpecificPlantData with fullscan;
    update statistics pdmlink.ERPPartSpecificPlantDataLink with fullscan;
    update statistics pdmlink.EventLog with fullscan;
    update statistics pdmlink.ExchangeContainer with fullscan;
    update statistics pdmlink.ExplicitBusinessField with fullscan;
    update statistics pdmlink.ExportEventInfo with fullscan;
    update statistics pdmlink.ExportRecord with fullscan;
    update statistics pdmlink.ExpressionAlias with fullscan;
    update statistics pdmlink.ExpressionAliasMaster with fullscan;
    update statistics pdmlink.ExpressionAliasMasterKey with fullscan;
    update statistics pdmlink.expressionAliasNumber_seq with fullscan;
    update statistics pdmlink.ExpressionMemberLink with fullscan;
    update statistics pdmlink.expressionNumber_seq with fullscan;
    update statistics pdmlink.ExtendedPageResults with fullscan;
    update statistics pdmlink.ExternalLogicLink with fullscan;
    update statistics pdmlink.ExternalStoredData with fullscan;
    update statistics pdmlink.FacilityResource with fullscan;
    update statistics pdmlink.FederatableRepositoryStatus with fullscan;
    update statistics pdmlink.FederatedDirectoryService with fullscan;
    update statistics pdmlink.FederatedInfoEngineService with fullscan;
    update statistics pdmlink.FederatedLink with fullscan;
    update statistics pdmlink.FederationLock with fullscan;
    update statistics pdmlink.Fidelity with fullscan;
    update statistics pdmlink.filenameusn_seq with fullscan;
    update statistics pdmlink.FilterCriterionDef with fullscan;
    update statistics pdmlink.FilterCriterionDefMaster with fullscan;
    update statistics pdmlink.FilteredDynamicEnumSet with fullscan;
    update statistics pdmlink.FindSimilarObjectEventInfo with fullscan;
    update statistics pdmlink.FlexibleChangeConverterState with fullscan;
    update statistics pdmlink.FloatDefinition with fullscan;
    update statistics pdmlink.FloatingBaselineMember with fullscan;
    update statistics pdmlink.FloatValue with fullscan;
    update statistics pdmlink.FolderedBookmark with fullscan;
    update statistics pdmlink.FolderMemberLink with fullscan;
    update statistics pdmlink.FormalizedBy with fullscan;
    update statistics pdmlink.ForumCookie with fullscan;
    update statistics pdmlink.ForumSubjectLink with fullscan;
    update statistics pdmlink.FvFolder with fullscan;
    update statistics pdmlink.FvFraction with fullscan;
    update statistics pdmlink.FvHost with fullscan;
    update statistics pdmlink.FvItem with fullscan;
    update statistics pdmlink.FvMount with fullscan;
    update statistics pdmlink.FvMountValidatorLock with fullscan;
    update statistics pdmlink.FvPolicyItem with fullscan;
    update statistics pdmlink.FvPolicyRule with fullscan;
    update statistics pdmlink.FvServicePersistentFlags with fullscan;
    update statistics pdmlink.FvVault with fullscan;
    update statistics pdmlink.GenericizableTemplateLink with fullscan;
    update statistics pdmlink.GenericVariantLink with fullscan;
    update statistics pdmlink.HandshakeLocks with fullscan;
    update statistics pdmlink.HangingChangeLink with fullscan;
    update statistics pdmlink.HistoryRecord with fullscan;
    update statistics pdmlink.HistoryRecordLink with fullscan;
    update statistics pdmlink.HistoryXML with fullscan;
    update statistics pdmlink.HistoryXMLLink with fullscan;
    update statistics pdmlink.HolderToContent with fullscan;
    update statistics pdmlink.HTMLLog with fullscan;
    update statistics pdmlink.HTMLLogMessage with fullscan;
    update statistics pdmlink.HttpContentOperation with fullscan;
    update statistics pdmlink.HttpOperationItem with fullscan;
    update statistics pdmlink.IAEContextLink with fullscan;
    update statistics pdmlink.IAEConvertedObject with fullscan;
    update statistics pdmlink.id_sequence with fullscan;
    update statistics pdmlink.IdentityChangeHistory with fullscan;
    update statistics pdmlink.ImpactedTestObject with fullscan;
    update statistics pdmlink.ImpactedTestObjectMaster with fullscan;
    update statistics pdmlink.ImpactLink with fullscan;
    update statistics pdmlink.ImpactorTestObject with fullscan;
    update statistics pdmlink.ImpactorTestObjectMaster with fullscan;
    update statistics pdmlink.Impacts with fullscan;
    update statistics pdmlink.ImportedBookmark with fullscan;
    update statistics pdmlink.ImportFromXlsStaging with fullscan;
    update statistics pdmlink.ImportJob with fullscan;
    update statistics pdmlink.ImportJobNumberSeq with fullscan;
    update statistics pdmlink.ImportSession with fullscan;
    update statistics pdmlink.Inbox with fullscan;
    update statistics pdmlink.IncludedIn2 with fullscan;
    update statistics pdmlink.IndAssignedExpression with fullscan;
    update statistics pdmlink.IndAssignedExpressionMaster with fullscan;
    update statistics pdmlink.IndependentNavStruct with fullscan;
    update statistics pdmlink.IndependentNode with fullscan;
    update statistics pdmlink.IndexPolicy with fullscan;
    update statistics pdmlink.IndexPolicyList with fullscan;
    update statistics pdmlink.IndexPolicyRule with fullscan;
    update statistics pdmlink.IndexStatus with fullscan;
    update statistics pdmlink.IndirectQueryTarget with fullscan;
    update statistics pdmlink.IndividualLicenseUsage with fullscan;
    update statistics pdmlink.InfoEngineTranslationTable with fullscan;
    update statistics pdmlink.InformationResource with fullscan;
    update statistics pdmlink.InputValue with fullscan;
    update statistics pdmlink.InstanceBasedRule with fullscan;
    update statistics pdmlink.InstanceReplacementRecord with fullscan;
    update statistics pdmlink.InstrumentedAssemblyFilter with fullscan;
    update statistics pdmlink.IntegerDefinition with fullscan;
    update statistics pdmlink.IntegerValue with fullscan;
    update statistics pdmlink.IssueImplementedBy with fullscan;
    update statistics pdmlink.IteratedActionItemSubjectLink with fullscan;
    update statistics pdmlink.IteratedCurrentPhaseLink with fullscan;
    update statistics pdmlink.IteratedForumSubjectLink with fullscan;
    update statistics pdmlink.IteratedNotebookSubjectLink with fullscan;
    update statistics pdmlink.IteratedShortcutLink with fullscan;
    update statistics pdmlink.IteratedToEPMDocumentLink with fullscan;
    update statistics pdmlink.IterFolderMemberLink with fullscan;
    update statistics pdmlink.IxbDBObject with fullscan;
    update statistics pdmlink.ixbdbobjectid_seq with fullscan;
    update statistics pdmlink.IxbElementContext with fullscan;
    update statistics pdmlink.IxbObjectAttr with fullscan;
    update statistics pdmlink.IxbPersistableArtifact with fullscan;
    update statistics pdmlink.IxExistingObjectInfo with fullscan;
    update statistics pdmlink.IxStagingDBTag with fullscan;
    update statistics pdmlink.IxStagingDBTagLink with fullscan;
    update statistics pdmlink.JmxNotifications with fullscan;
    update statistics pdmlink.JobToBaselineLink with fullscan;
    update statistics pdmlink.JobToQueueEntryLink with fullscan;
    update statistics pdmlink.JobToTrackableLink with fullscan;
    update statistics pdmlink.LicenseCountHistory with fullscan;
    update statistics pdmlink.LicenseNotification with fullscan;
    update statistics pdmlink.LicenseProfile with fullscan;
    update statistics pdmlink.LifeCycleHistory with fullscan;
    update statistics pdmlink.LifeCycleManagedWtMarkUp with fullscan;
    update statistics pdmlink.LifeCycleSignature with fullscan;
    update statistics pdmlink.LifeCycleTemplate with fullscan;
    update statistics pdmlink.LifeCycleTemplateMaster with fullscan;
    update statistics pdmlink.LightweightProxy with fullscan;
    update statistics pdmlink.LocationChangeRecord with fullscan;
    update statistics pdmlink.Log4JavascriptEvents with fullscan;
    update statistics pdmlink.LogicalIdentifierMapEntry with fullscan;
    update statistics pdmlink.LotBaseline with fullscan;
    update statistics pdmlink.LotBaselineidentity_seq with fullscan;
    update statistics pdmlink.LotBaselineKey with fullscan;
    update statistics pdmlink.LotBaselineMemberContext with fullscan;
    update statistics pdmlink.LWCAttDependencyLink with fullscan;
    update statistics pdmlink.LWCAttributeDefaultValue with fullscan;
    update statistics pdmlink.LWCAttributeDisplayStyle with fullscan;
    update statistics pdmlink.LWCAttributeSetAttDefinition with fullscan;
    update statistics pdmlink.LWCBasicConstraint with fullscan;
    update statistics pdmlink.LWCColumnAllocation with fullscan;
    update statistics pdmlink.LWCConstraintConditionLink with fullscan;
    update statistics pdmlink.LWCConstraintRuleDefinition with fullscan;
    update statistics pdmlink.LWCContentHolderPropertyValue with fullscan;
    update statistics pdmlink.LWCDatatypeDefinition with fullscan;
    update statistics pdmlink.LWCDynamicGroupDefinition with fullscan;
    update statistics pdmlink.LWCDynamicLogicalAttDefinition with fullscan;
    update statistics pdmlink.LWCEnumerationBasedConstraint with fullscan;
    update statistics pdmlink.LWCEnumerationDefinition with fullscan;
    update statistics pdmlink.LWCEnumerationEntry with fullscan;
    update statistics pdmlink.LWCEnumerationEntryLink with fullscan;
    update statistics pdmlink.LWCFilterBasedConstraint with fullscan;
    update statistics pdmlink.LWCFlexAttDefinition with fullscan;
    update statistics pdmlink.LWCGroupDisplayStyle with fullscan;
    update statistics pdmlink.LWCGroupMembership with fullscan;
    update statistics pdmlink.LWCHardAttDefinition with fullscan;
    update statistics pdmlink.LWCIBAAttDefinition with fullscan;
    update statistics pdmlink.LWCImageAttComponentDefinition with fullscan;
    update statistics pdmlink.LWCLayoutDefinition with fullscan;
    update statistics pdmlink.LWCLayoutProfileLink with fullscan;
    update statistics pdmlink.LWCLayoutScreenLink with fullscan;
    update statistics pdmlink.LWCLinkedFlexAttDefinition with fullscan;
    update statistics pdmlink.LWCLocalizablePropertyValue with fullscan;
    update statistics pdmlink.LWCLogicalAttDefinition with fullscan;
    update statistics pdmlink.LWCMasterEnumerationDefinition with fullscan;
    update statistics pdmlink.LWCNestedLayoutDefinition with fullscan;
    update statistics pdmlink.LWCNonPersistedAttDefinition with fullscan;
    update statistics pdmlink.LWCOrganizer with fullscan;
    update statistics pdmlink.LWCPropertyDefinition with fullscan;
    update statistics pdmlink.LWCPropertyValue with fullscan;
    update statistics pdmlink.LWCScreenDefinition with fullscan;
    update statistics pdmlink.LWCSeparator with fullscan;
    update statistics pdmlink.LWCStaticGroupDefinition with fullscan;
    update statistics pdmlink.LWCStructEnumAttTemplate with fullscan;
    update statistics pdmlink.LWCTableDefinition with fullscan;
    update statistics pdmlink.LWCTranslatedTextAttDefinition with fullscan;
    update statistics pdmlink.LWCTypeDefinition with fullscan;
    update statistics pdmlink.LWWfAssignedActivity with fullscan;
    update statistics pdmlink.LWWfAssignmentEventAudit with fullscan;
    update statistics pdmlink.LWWfProcess with fullscan;
    update statistics pdmlink.LWWfVotingEventAudit with fullscan;
    update statistics pdmlink.LWWorkItem with fullscan;
    update statistics pdmlink.MadeFromLink with fullscan;
    update statistics pdmlink.ManagedBaseline with fullscan;
    update statistics pdmlink.managedbaselineidentity_seq with fullscan;
    update statistics pdmlink.ManagedBaselineKey with fullscan;
    update statistics pdmlink.ManagedCollection with fullscan;
    update statistics pdmlink.ManagedCollectionKey with fullscan;
    update statistics pdmlink.ManagedCollectionSequence with fullscan;
    update statistics pdmlink.markfordelete_seq with fullscan;
    update statistics pdmlink.MarkupAnnotateEventInfo with fullscan;
    update statistics pdmlink.MasteredOnReplicaItem with fullscan;
    update statistics pdmlink.MaterialResource with fullscan;
    update statistics pdmlink.MaturityBaseline with fullscan;
    update statistics pdmlink.MaturityKey with fullscan;
    update statistics pdmlink.MeasurementSystem with fullscan;
    update statistics pdmlink.MeetingCenterMeeting with fullscan;
    update statistics pdmlink.MeetingDeliverable with fullscan;
    update statistics pdmlink.MeetingParticipantLink with fullscan;
    update statistics pdmlink.MeetingSubjectLink with fullscan;
    update statistics pdmlink.MembershipLink with fullscan;
    update statistics pdmlink.MergeInfoLink with fullscan;
    update statistics pdmlink.MethodContexts with fullscan;
    update statistics pdmlink.MethodContextStats with fullscan;
    update statistics pdmlink.MethodDef with fullscan;
    update statistics pdmlink.MethodDefMaster with fullscan;
    update statistics pdmlink.MethodServerInfo with fullscan;
    update statistics pdmlink.Milestone with fullscan;
    update statistics pdmlink.MilestoneTemplate with fullscan;
    update statistics pdmlink.MinutesDocumentLink with fullscan;
    update statistics pdmlink.MiscLogEvents with fullscan;
    update statistics pdmlink.MissingRepObjectLinkSource with fullscan;
    update statistics pdmlink.MissingRepObjectLinkTarget with fullscan;
    update statistics pdmlink.MissingRepObjectSource with fullscan;
    update statistics pdmlink.MissingRepObjectTarget with fullscan;
    update statistics pdmlink.ModelItem with fullscan;
    update statistics pdmlink.ModelItemContainedIn with fullscan;
    update statistics pdmlink.ModelItemLink with fullscan;
    update statistics pdmlink.ModelItemMaster with fullscan;
    update statistics pdmlink.ModelItemPartLink with fullscan;
    update statistics pdmlink.ModifyAccessPolicyEventInfo with fullscan;
    update statistics pdmlink.ModifyContentEventInfo with fullscan;
    update statistics pdmlink.ModifyGroupEventInfo with fullscan;
    update statistics pdmlink.ModifyObjectAccessEventInfo with fullscan;
    update statistics pdmlink.ModifyOrgRoleEventInfo with fullscan;
    update statistics pdmlink.ModifyProdStructureEventInfo with fullscan;
    update statistics pdmlink.ModifySecurityLabelsEventInfo with fullscan;
    update statistics pdmlink.ModifyTeamEventInfo with fullscan;
    update statistics pdmlink.ModifyTeamRoleEventInfo with fullscan;
    update statistics pdmlink.ModuleVariantFilter with fullscan;
    update statistics pdmlink.ModuleVariantSelectRule with fullscan;
    update statistics pdmlink.MoveEventInfo with fullscan;
    update statistics pdmlink.MSHealthStats with fullscan;
    update statistics pdmlink.MultiFidelityDerivedImage with fullscan;
    update statistics pdmlink.MultiValuedPreferenceInstance with fullscan;
    update statistics pdmlink.MVPInstanceDeleteRecord with fullscan;
    update statistics pdmlink.NavCriteriaConfigSpecLink with fullscan;
    update statistics pdmlink.NavFilterConstraint with fullscan;
    update statistics pdmlink.NavFilterDesignationLink with fullscan;
    update statistics pdmlink.NavigationCriteria with fullscan;
    update statistics pdmlink.NavigationFilter with fullscan;
    update statistics pdmlink.NavigationFilterTemplate with fullscan;
    update statistics pdmlink.NetworkLink with fullscan;
    update statistics pdmlink.NodeQueryForm with fullscan;
    update statistics pdmlink.NodeTemplateLink with fullscan;
    update statistics pdmlink.NotAuthorizedAccessEventInfo with fullscan;
    update statistics pdmlink.Notebook with fullscan;
    update statistics pdmlink.NotebookFolder with fullscan;
    update statistics pdmlink.NotebookSubjectLink with fullscan;
    update statistics pdmlink.NotebookTemplate with fullscan;
    update statistics pdmlink.NoteHolderNoteLink with fullscan;
    update statistics pdmlink.NotificationList with fullscan;
    update statistics pdmlink.NotificationRule with fullscan;
    update statistics pdmlink.NotificationSubscription with fullscan;
    update statistics pdmlink.NotifySubscriptionRecipient with fullscan;
    update statistics pdmlink.NotifySubscriptionTarget with fullscan;
    update statistics pdmlink.O2SM_PARAMETER with fullscan;
    update statistics pdmlink.O2SM_RESULT with fullscan;
    update statistics pdmlink.O2SM_TASK with fullscan;
    update statistics pdmlink.O2SM_TASK_LOG with fullscan;
    update statistics pdmlink.ObjectDeletionEvent with fullscan;
    update statistics pdmlink.ObjectFilter with fullscan;
    update statistics pdmlink.ObjectHistory with fullscan;
    update statistics pdmlink.ObjectSubscription with fullscan;
    update statistics pdmlink.ObjectTagFilter with fullscan;
    update statistics pdmlink.ObjTypeCriterionDef with fullscan;
    update statistics pdmlink.ObjTypeCriterionDefMaster with fullscan;
    update statistics pdmlink.occurrencedataidentifier_seq with fullscan;
    update statistics pdmlink.occurrenceidentifier_seq with fullscan;
    update statistics pdmlink.Octree with fullscan;
    update statistics pdmlink.OpLink with fullscan;
    update statistics pdmlink.OptionChoiceMasterLink with fullscan;
    update statistics pdmlink.OptionExclusionReference with fullscan;
    update statistics pdmlink.OptionMasterKey with fullscan;
    update statistics pdmlink.optionNumber_seq with fullscan;
    update statistics pdmlink.OptionSet with fullscan;
    update statistics pdmlink.OptionSetChoiceRuleLink with fullscan;
    update statistics pdmlink.OptionSetChoiceRuleMasterLink with fullscan;
    update statistics pdmlink.OptionSetIgnoreChoiceRuleLink with fullscan;
    update statistics pdmlink.OptionSetMaster with fullscan;
    update statistics pdmlink.OptionSetMasterKey with fullscan;
    update statistics pdmlink.OptionSetMemberLink with fullscan;
    update statistics pdmlink.OrgContainer with fullscan;
    update statistics pdmlink.OrgFilter with fullscan;
    update statistics pdmlink.OutOfDateRepresentationLink with fullscan;
    update statistics pdmlink.OverdueWorkItemLink with fullscan;
    update statistics pdmlink.OverrideRegOptionSetLink with fullscan;
    update statistics pdmlink.OwnerChangeEvent with fullscan;
    update statistics pdmlink.OwningRepositoryLocalObject with fullscan;
    update statistics pdmlink.PackageExportRecord with fullscan;
    update statistics pdmlink.PageResults with fullscan;
    update statistics pdmlink.PagingSession with fullscan;
    update statistics pdmlink.ParameterAttributeDefnLink with fullscan;
    update statistics pdmlink.PartCombinedPathOccurrence with fullscan;
    update statistics pdmlink.PartCreationStatus with fullscan;
    update statistics pdmlink.PartExportInfo with fullscan;
    update statistics pdmlink.PARToCARBuildLink with fullscan;
    update statistics pdmlink.PartPathOccurrence with fullscan;
    update statistics pdmlink.PartTagLink with fullscan;
    update statistics pdmlink.PartUsesOccurrence with fullscan;
    update statistics pdmlink.PathFilter with fullscan;
    update statistics pdmlink.PathOccurrenceDataMaster with fullscan;
    update statistics pdmlink.PathOccurrenceDocumentation with fullscan;
    update statistics pdmlink.PathOccurrenceUserIBAs with fullscan;
    update statistics pdmlink.PayloadShippingItem with fullscan;
    update statistics pdmlink.PCategoryDeleteRecord with fullscan;
    update statistics pdmlink.PCategoryLinkDeleteRecord with fullscan;
    update statistics pdmlink.PClientDeleteRecord with fullscan;
    update statistics pdmlink.PClientLinkDeleteRecord with fullscan;
    update statistics pdmlink.PDefinitionDeleteRecord with fullscan;
    update statistics pdmlink.PDMCheckoutEventInfo with fullscan;
    update statistics pdmlink.PDMLinkProduct with fullscan;
    update statistics pdmlink.PendingBlockEffectivity with fullscan;
    update statistics pdmlink.PendingDateEffectivity with fullscan;
    update statistics pdmlink.PendingLNEffectivity with fullscan;
    update statistics pdmlink.PendingMSNEffectivity with fullscan;
    update statistics pdmlink.PendingSNEffectivity with fullscan;
    update statistics pdmlink.PerDestinationOutbox with fullscan;
    update statistics pdmlink.PersistableEffConfigSpec with fullscan;
    update statistics pdmlink.PersistantArg with fullscan;
    update statistics pdmlink.PersistedCollection with fullscan;
    update statistics pdmlink.PersistedCollectionCloneLink with fullscan;
    update statistics pdmlink.PersistedCollectionFrozenLink with fullscan;
    update statistics pdmlink.PersistedCollectionLiveLink with fullscan;
    update statistics pdmlink.PersistedCollectionNestingLink with fullscan;
    update statistics pdmlink.PersistedCollectionRecipe with fullscan;
    update statistics pdmlink.PersistedCollectionSequence with fullscan;
    update statistics pdmlink.PersistedCollectionTombHolder with fullscan;
    update statistics pdmlink.PersistedCollectionTombstone with fullscan;
    update statistics pdmlink.PersistedProperty with fullscan;
    update statistics pdmlink.PersistentInbox with fullscan;
    update statistics pdmlink.PersistentTrackingNumGen with fullscan;
    update statistics pdmlink.PersonResource with fullscan;
    update statistics pdmlink.Phase with fullscan;
    update statistics pdmlink.PhaseLink with fullscan;
    update statistics pdmlink.PhaseSuccession with fullscan;
    update statistics pdmlink.PhaseTemplate with fullscan;
    update statistics pdmlink.PInstanceDeleteRecord with fullscan;
    update statistics pdmlink.placeholderid_seq with fullscan;
    update statistics pdmlink.PlantDataLink with fullscan;
    update statistics pdmlink.PlantFunctionalData with fullscan;
    update statistics pdmlink.PlantFunctionalDataLink with fullscan;
    update statistics pdmlink.PlantFunctionalDataMaster with fullscan;
    update statistics pdmlink.PluginCategory with fullscan;
    update statistics pdmlink.PolicyAcl with fullscan;
    update statistics pdmlink.PostingAttachmentLink with fullscan;
    update statistics pdmlink.PQStats with fullscan;
    update statistics pdmlink.PredictiveCachingRule with fullscan;
    update statistics pdmlink.PredictiveCachingRuleVersion with fullscan;
    update statistics pdmlink.PreferenceCategory with fullscan;
    update statistics pdmlink.PreferenceCategoryDefinition with fullscan;
    update statistics pdmlink.PreferenceClient with fullscan;
    update statistics pdmlink.PreferenceClientDefinition with fullscan;
    update statistics pdmlink.PreferenceDefinition with fullscan;
    update statistics pdmlink.PreferenceInstance with fullscan;
    update statistics pdmlink.PrimitiveArg with fullscan;
    update statistics pdmlink.ProblemProduct with fullscan;
    update statistics pdmlink.ProcessingQueue with fullscan;
    update statistics pdmlink.ProcessStepTemplateLink with fullscan;
    update statistics pdmlink.ProductBlockEffectivity with fullscan;
    update statistics pdmlink.ProductDateEffectivity with fullscan;
    update statistics pdmlink.ProductFamily with fullscan;
    update statistics pdmlink.ProductFamilyIDSequence with fullscan;
    update statistics pdmlink.ProductFamilyMaster with fullscan;
    update statistics pdmlink.ProductFamilyMasterKey with fullscan;
    update statistics pdmlink.ProductFamilyMemberUsageLink with fullscan;
    update statistics pdmlink.ProductLNEffectivity with fullscan;
    update statistics pdmlink.ProductModel with fullscan;
    update statistics pdmlink.ProductModelGroup with fullscan;
    update statistics pdmlink.ProductModelGroupIDSequence with fullscan;
    update statistics pdmlink.ProductModelGroupMaster with fullscan;
    update statistics pdmlink.ProductModelGroupMasterKey with fullscan;
    update statistics pdmlink.ProductModelIDSequence with fullscan;
    update statistics pdmlink.ProductModelMaster with fullscan;
    update statistics pdmlink.ProductModelMasterKey with fullscan;
    update statistics pdmlink.ProductMSNEffectivity with fullscan;
    update statistics pdmlink.ProductPlanTemplate with fullscan;
    update statistics pdmlink.ProductSNEffectivity with fullscan;
    update statistics pdmlink.Project with fullscan;
    update statistics pdmlink.Project2 with fullscan;
    update statistics pdmlink.project2_seq with fullscan;
    update statistics pdmlink.ProjectActivity with fullscan;
    update statistics pdmlink.ProjectActivityTemplate with fullscan;
    update statistics pdmlink.ProjectAssignment with fullscan;
    update statistics pdmlink.ProjectPlan with fullscan;
    update statistics pdmlink.ProjectPlanTemplate with fullscan;
    update statistics pdmlink.ProjectProxy with fullscan;
    update statistics pdmlink.ProjectProxyTemplate with fullscan;
    update statistics pdmlink.ProjectWorkItem with fullscan;
    update statistics pdmlink.PromotionNotice with fullscan;
    update statistics pdmlink.promotionnoticeid_seq with fullscan;
    update statistics pdmlink.PromotionSeed with fullscan;
    update statistics pdmlink.PromotionTarget with fullscan;
    update statistics pdmlink.ProxyDocument with fullscan;
    update statistics pdmlink.ProxyDocumentMaster with fullscan;
    update statistics pdmlink.ProxyGroup with fullscan;
    update statistics pdmlink.ProxyPartMaster with fullscan;
    update statistics pdmlink.ProxyURLData with fullscan;
    update statistics pdmlink.ProxyUser with fullscan;
    update statistics pdmlink.PublishedContentLink with fullscan;
    update statistics pdmlink.PublishedLineNumber with fullscan;
    update statistics pdmlink.PublishingProhibition with fullscan;
    update statistics pdmlink.PublishingSummary with fullscan;
    update statistics pdmlink.PurgeRecord with fullscan;
    update statistics pdmlink.PurgeSchedule with fullscan;
    update statistics pdmlink.QuantityOfMeasure with fullscan;
    update statistics pdmlink.QuarantinedDescription with fullscan;
    update statistics pdmlink.QueryFormElement with fullscan;
    update statistics pdmlink.QueueEntry with fullscan;
    update statistics pdmlink.QueueLock with fullscan;
    update statistics pdmlink.RankingContext with fullscan;
    update statistics pdmlink.RankingData with fullscan;
    update statistics pdmlink.RatioDefinition with fullscan;
    update statistics pdmlink.RatioValue with fullscan;
    update statistics pdmlink.RawMethodContextStats with fullscan;
    update statistics pdmlink.RawServletRequestStats with fullscan;
    update statistics pdmlink.Receipt with fullscan;
    update statistics pdmlink.ReceivedDelivery with fullscan;
    update statistics pdmlink.ReceivedDeliveryChunkInfo with fullscan;
    update statistics pdmlink.ReceivedDeliveryImportOption with fullscan;
    update statistics pdmlink.receivedDeliveryNumber_seq with fullscan;
    update statistics pdmlink.ReceivedPackage with fullscan;
    update statistics pdmlink.RecentUpdate with fullscan;
    update statistics pdmlink.RecordedHistory with fullscan;
    update statistics pdmlink.RecordedObjectHistory with fullscan;
    update statistics pdmlink.ReferenceDefinition with fullscan;
    update statistics pdmlink.ReferenceValue with fullscan;
    update statistics pdmlink.RegisteredNFTLink with fullscan;
    update statistics pdmlink.RegisteredOptionSetLink with fullscan;
    update statistics pdmlink.RelationshipDef with fullscan;
    update statistics pdmlink.RelationshipDefMaster with fullscan;
    update statistics pdmlink.RelationshipMap with fullscan;
    update statistics pdmlink.RelationshipMapDef with fullscan;
    update statistics pdmlink.RelationshipMapDefMaster with fullscan;
    update statistics pdmlink.ReleasedConfigurationBaseline with fullscan;
    update statistics pdmlink.RelevantAnalysisData with fullscan;
    update statistics pdmlink.RelevantRequestData2 with fullscan;
    update statistics pdmlink.RemoteCacheServerCalls with fullscan;
    update statistics pdmlink.RemoteObjectId with fullscan;
    update statistics pdmlink.RemoteObjectInfo with fullscan;
    update statistics pdmlink.RemoteSiteTeamTemplate with fullscan;
    update statistics pdmlink.RemoteSiteTeamTemplateLink with fullscan;
    update statistics pdmlink.ReplicaFolder with fullscan;
    update statistics pdmlink.ReplicatedItem with fullscan;
    update statistics pdmlink.ReplicationBaseline with fullscan;
    update statistics pdmlink.ReplicationPackage with fullscan;
    update statistics pdmlink.ReplicationPackageMaster with fullscan;
    update statistics pdmlink.ReplicaVault with fullscan;
    update statistics pdmlink.Report with fullscan;
    update statistics pdmlink.ReportCriteria with fullscan;
    update statistics pdmlink.ReportedAgainst with fullscan;
    update statistics pdmlink.ReportTemplate with fullscan;
    update statistics pdmlink.ReportTemplateViewLink with fullscan;
    update statistics pdmlink.Repository with fullscan;
    update statistics pdmlink.RepresentableConfigSpecLink with fullscan;
    update statistics pdmlink.RepresentableNavCriteriaLink with fullscan;
    update statistics pdmlink.RequestHistograms with fullscan;
    update statistics pdmlink.RequiredDepend with fullscan;
    update statistics pdmlink.Requirement with fullscan;
    update statistics pdmlink.requirementid_seq with fullscan;
    update statistics pdmlink.RequirementMaster with fullscan;
    update statistics pdmlink.RequirementMasterKey with fullscan;
    update statistics pdmlink.ResearchedBy with fullscan;
    update statistics pdmlink.ReservableTestObject with fullscan;
    update statistics pdmlink.ResourceAssignmentLink with fullscan;
    update statistics pdmlink.RestoreRecord with fullscan;
    update statistics pdmlink.ResultStructFilter with fullscan;
    update statistics pdmlink.ResultStructFilterRule with fullscan;
    update statistics pdmlink.RevaultingSession with fullscan;
    update statistics pdmlink.ReVaultSessionId with fullscan;
    update statistics pdmlink.RevaultUrlSession with fullscan;
    update statistics pdmlink.RmiHistograms with fullscan;
    update statistics pdmlink.RmiPerfData with fullscan;
    update statistics pdmlink.RMIStubs with fullscan;
    update statistics pdmlink.RoleActorRoleMap with fullscan;
    update statistics pdmlink.RolePoolMap with fullscan;
    update statistics pdmlink.RolePrincipalMap with fullscan;
    update statistics pdmlink.RoleResource with fullscan;
    update statistics pdmlink.RoleRoleMap with fullscan;
    update statistics pdmlink.RootFolder with fullscan;
    update statistics pdmlink.RootMount with fullscan;
    update statistics pdmlink.RuleMemberActionLink with fullscan;
    update statistics pdmlink.RvStreamIdCounter with fullscan;
    update statistics pdmlink.SampledMethodContexts with fullscan;
    update statistics pdmlink.SampledServletRequests with fullscan;
    update statistics pdmlink.SandboxBaseline with fullscan;
    update statistics pdmlink.SandboxCheckinLink with fullscan;
    update statistics pdmlink.SandboxCheckoutLink with fullscan;
    update statistics pdmlink.SavedChart with fullscan;
    update statistics pdmlink.SavedQuery with fullscan;
    update statistics pdmlink.SavedQueryPrincipalLink with fullscan;
    update statistics pdmlink.SavedReportHolder with fullscan;
    update statistics pdmlink.sch_entries with fullscan;
    update statistics pdmlink.ScheduleHistory with fullscan;
    update statistics pdmlink.ScheduleItem with fullscan;
    update statistics pdmlink.ScheduleQueue with fullscan;
    update statistics pdmlink.ScheduleQueueEntry with fullscan;
    update statistics pdmlink.ScheduleRecordLink with fullscan;
    update statistics pdmlink.ScmAdapter with fullscan;
    update statistics pdmlink.ScmApplicationData with fullscan;
    update statistics pdmlink.ScmConfigSpec with fullscan;
    update statistics pdmlink.ScmFileData with fullscan;
    update statistics pdmlink.ScmLabel with fullscan;
    update statistics pdmlink.ScmSpecData with fullscan;
    update statistics pdmlink.ScmView with fullscan;
    update statistics pdmlink.SearchEventInfo with fullscan;
    update statistics pdmlink.SearchHistory with fullscan;
    update statistics pdmlink.SecurityLabelFilter with fullscan;
    update statistics pdmlink.SemanticKey with fullscan;
    update statistics pdmlink.SentToPrintEventInfo with fullscan;
    update statistics pdmlink.seqNumber_seq with fullscan;
    update statistics pdmlink.SerialNumberMapping with fullscan;
    update statistics pdmlink.SeriesSortValue with fullscan;
    update statistics pdmlink.SeriesTemplate with fullscan;
    update statistics pdmlink.ServerManagerInfo with fullscan;
    update statistics pdmlink.ServletRequests with fullscan;
    update statistics pdmlink.ServletRequestStats with fullscan;
    update statistics pdmlink.ServletSessionStats with fullscan;
    update statistics pdmlink.ShadowBaseline with fullscan;
    update statistics pdmlink.ShadowCache with fullscan;
    update statistics pdmlink.ShadowClass with fullscan;
    update statistics pdmlink.ShadowContext with fullscan;
    update statistics pdmlink.ShadowContextToContextLink with fullscan;
    update statistics pdmlink.ShadowLink with fullscan;
    update statistics pdmlink.ShadowTarget with fullscan;
    update statistics pdmlink.SharedContainerMap with fullscan;
    update statistics pdmlink.SharedLocalTeamLink with fullscan;
    update statistics pdmlink.ShareEventInfo with fullscan;
    update statistics pdmlink.ShortcutLink with fullscan;
    update statistics pdmlink.ShowAdvancedFindCriteriaLink with fullscan;
    update statistics pdmlink.ShowSharedNavCriteriaLink with fullscan;
    update statistics pdmlink.SignatureHistory with fullscan;
    update statistics pdmlink.SignatureLink with fullscan;
    update statistics pdmlink.SimpleNestedCollection with fullscan;
    update statistics pdmlink.SimpleStructFilterRule with fullscan;
    update statistics pdmlink.Site with fullscan;
    update statistics pdmlink.SiteProximity with fullscan;
    update statistics pdmlink.SiteSecurity with fullscan;
    update statistics pdmlink.SiteToSitePrincipalLink with fullscan;
    update statistics pdmlink.SLChangeHistory with fullscan;
    update statistics pdmlink.SLDownloadAckEventInfo with fullscan;
    update statistics pdmlink.SmartToolbarDescriptor with fullscan;
    update statistics pdmlink.SMHealthStats with fullscan;
    update statistics pdmlink.SoftAttributeDefinition with fullscan;
    update statistics pdmlink.SoftAttributeOrganizer with fullscan;
    update statistics pdmlink.SoftAttributeValue with fullscan;
    update statistics pdmlink.SpatialStructFilter with fullscan;
    update statistics pdmlink.SpatialStructFilterRule with fullscan;
    update statistics pdmlink.Specification with fullscan;
    update statistics pdmlink.SpecificationIDSeq with fullscan;
    update statistics pdmlink.SpecificationMaster with fullscan;
    update statistics pdmlink.SpecificationTemplate with fullscan;
    update statistics pdmlink.SpecificationUsageLink with fullscan;
    update statistics pdmlink.SpecMasterKey with fullscan;
    update statistics pdmlink.SpecTemplateMaster with fullscan;
    update statistics pdmlink.SQStats with fullscan;
    update statistics pdmlink.StandardProfile with fullscan;
    update statistics pdmlink.StateChangeEvent with fullscan;
    update statistics pdmlink.StatusChangeEvent with fullscan;
    update statistics pdmlink.StopIfSimplifiedFilter with fullscan;
    update statistics pdmlink.StreamData with fullscan;
    update statistics pdmlink.StreamedToFvFractionLink with fullscan;
    update statistics pdmlink.streamId_seq with fullscan;
    update statistics pdmlink.StreamIdentity with fullscan;
    update statistics pdmlink.StringDefinition with fullscan;
    update statistics pdmlink.StringValue with fullscan;
    update statistics pdmlink.StructuredAnnotationSet with fullscan;
    update statistics pdmlink.SubFolder with fullscan;
    update statistics pdmlink.SubFolderLink with fullscan;
    update statistics pdmlink.SubFolderLinkConstraint with fullscan;
    update statistics pdmlink.SubjectProduct with fullscan;
    update statistics pdmlink.SummaryActivity with fullscan;
    update statistics pdmlink.SummaryActivityTemplate with fullscan;
    update statistics pdmlink.SupersedeGroup with fullscan;
    update statistics pdmlink.SupersedeHistory with fullscan;
    update statistics pdmlink.SupersedeLink with fullscan;
    update statistics pdmlink.SupportingDataFor with fullscan;
    update statistics pdmlink.SyncContentManifest with fullscan;
    update statistics pdmlink.SyncInfo with fullscan;
    update statistics pdmlink.TableStructureHash with fullscan;
    update statistics pdmlink.TableViewDescriptor with fullscan;
    update statistics pdmlink.TaskEvent with fullscan;
    update statistics pdmlink.TaskEventAffectedObjectsLink with fullscan;
    update statistics pdmlink.TaskEventData with fullscan;
    update statistics pdmlink.TaskEventMessage with fullscan;
    update statistics pdmlink.TaskFormTemplate with fullscan;
    update statistics pdmlink.TaskFormTemplateMaster with fullscan;
    update statistics pdmlink.TaskTabToPboActionsLink with fullscan;
    update statistics pdmlink.Team with fullscan;
    update statistics pdmlink.TeamDistributionList with fullscan;
    update statistics pdmlink.TEAMID_seq with fullscan;
    update statistics pdmlink.TeamTemplate with fullscan;
    update statistics pdmlink.TechnicalDataPackage with fullscan;
    update statistics pdmlink.TechnicalDataPackageMaster with fullscan;
    update statistics pdmlink.TemplatedAgenda with fullscan;
    update statistics pdmlink.TemplatedMinutes with fullscan;
    update statistics pdmlink.TemplateToTabLink with fullscan;
    update statistics pdmlink.TextAgenda with fullscan;
    update statistics pdmlink.TextMinutes with fullscan;
    update statistics pdmlink.TheMarkUpTheViewable with fullscan;
    update statistics pdmlink.ThirdPartyReportModelData with fullscan;
    update statistics pdmlink.TimestampDefinition with fullscan;
    update statistics pdmlink.TimestampValue with fullscan;
    update statistics pdmlink.ToDoItem with fullscan;
    update statistics pdmlink.TopicVisitData with fullscan;
    update statistics pdmlink.TopSQLStats with fullscan;
    update statistics pdmlink.trace_xe_action_map with fullscan;
    update statistics pdmlink.trace_xe_event_map with fullscan;
    update statistics pdmlink.TraditionalMeeting with fullscan;
    update statistics pdmlink.TransformFilterEntry with fullscan;
    update statistics pdmlink.TranslationDictionary with fullscan;
    update statistics pdmlink.TranslationDictionaryEntry with fullscan;
    update statistics pdmlink.TranslationLink with fullscan;
    update statistics pdmlink.TranslationMasterLink with fullscan;
    update statistics pdmlink.TransparentInbox with fullscan;
    update statistics pdmlink.TransparentOutbox with fullscan;
    update statistics pdmlink.TypeBasedRule with fullscan;
    update statistics pdmlink.TypeContainerConstraint with fullscan;
    update statistics pdmlink.TypedIteratedResource with fullscan;
    update statistics pdmlink.TypedIteratedResourceMaster with fullscan;
    update statistics pdmlink.TypeFilter with fullscan;
    update statistics pdmlink.TypeSingleAttrConstraint with fullscan;
    update statistics pdmlink.UfidMapping with fullscan;
    update statistics pdmlink.UIAccess with fullscan;
    update statistics pdmlink.UnitDefinition with fullscan;
    update statistics pdmlink.UnitExportRecord with fullscan;
    update statistics pdmlink.UnitImportRecord with fullscan;
    update statistics pdmlink.UnitReceiveRecord with fullscan;
    update statistics pdmlink.UnitSeedLink with fullscan;
    update statistics pdmlink.UnitSendRecord with fullscan;
    update statistics pdmlink.UnitValue with fullscan;
    update statistics pdmlink.UploadedContentData with fullscan;
    update statistics pdmlink.UploadStatus with fullscan;
    update statistics pdmlink.URLData with fullscan;
    update statistics pdmlink.URLDefinition with fullscan;
    update statistics pdmlink.URLValue with fullscan;
    update statistics pdmlink.UserAgentInfo with fullscan;
    update statistics pdmlink.UserElectronicIDLink with fullscan;
    update statistics pdmlink.UserSessionEventInfo with fullscan;
    update statistics pdmlink.UsesOccurrenceDocumentation with fullscan;
    update statistics pdmlink.UsesOccurrenceUserIBAs with fullscan;
    update statistics pdmlink.VarianceBlockEffectivity with fullscan;
    update statistics pdmlink.VarianceDateEffectivity with fullscan;
    update statistics pdmlink.VarianceLNEffectivity with fullscan;
    update statistics pdmlink.VarianceMSNEffectivity with fullscan;
    update statistics pdmlink.VarianceSNEffectivity with fullscan;
    update statistics pdmlink.VariantNameSeq with fullscan;
    update statistics pdmlink.VariantSpec with fullscan;
    update statistics pdmlink.variantspecid_seq with fullscan;
    update statistics pdmlink.VariantSpecMaster with fullscan;
    update statistics pdmlink.VariantSpecMasterKey with fullscan;
    update statistics pdmlink.VariantSpecVariantLink with fullscan;
    update statistics pdmlink.VariantsQueueEntryInfo with fullscan;
    update statistics pdmlink.VaultCleanupAuditLogs with fullscan;
    update statistics pdmlink.VersionEventInfo with fullscan;
    update statistics pdmlink.ViewAssociation with fullscan;
    update statistics pdmlink.ViewRepresentationsEventInfo with fullscan;
    update statistics pdmlink.VSEDViewFilter with fullscan;
    update statistics pdmlink.WAReportConfiguration with fullscan;
    update statistics pdmlink.WCTK_AHF_EPMFTValPK_Errs with fullscan;
    update statistics pdmlink.WfAdHocActivity with fullscan;
    update statistics pdmlink.WfAdHocActivityTemplate with fullscan;
    update statistics pdmlink.WfApplicationRobot with fullscan;
    update statistics pdmlink.WfApplRobotTemplate with fullscan;
    update statistics pdmlink.WfAssignedActivity with fullscan;
    update statistics pdmlink.WfAssignedActivityTemplate with fullscan;
    update statistics pdmlink.WfAssignment with fullscan;
    update statistics pdmlink.WfAssignmentEventAudit with fullscan;
    update statistics pdmlink.WfBallot with fullscan;
    update statistics pdmlink.WfBlock with fullscan;
    update statistics pdmlink.WfBlockTemplate with fullscan;
    update statistics pdmlink.WfBookmark with fullscan;
    update statistics pdmlink.WfConnector with fullscan;
    update statistics pdmlink.WfConnectorTemplate with fullscan;
    update statistics pdmlink.WfCreateProcessEventAudit with fullscan;
    update statistics pdmlink.WfDataEventAudit with fullscan;
    update statistics pdmlink.WfExceptionEventAudit with fullscan;
    update statistics pdmlink.WfExpression with fullscan;
    update statistics pdmlink.WfExpressionRobot with fullscan;
    update statistics pdmlink.WfExprRobotTemplate with fullscan;
    update statistics pdmlink.WfExternalMethod with fullscan;
    update statistics pdmlink.WfExternalMethodTemplate with fullscan;
    update statistics pdmlink.WfFolderedBookmark with fullscan;
    update statistics pdmlink.WfInternalMethod with fullscan;
    update statistics pdmlink.WfInternalMethodTemplate with fullscan;
    update statistics pdmlink.WfProcess with fullscan;
    update statistics pdmlink.WfProcessRequester with fullscan;
    update statistics pdmlink.WfProcessTemplate with fullscan;
    update statistics pdmlink.WfProcessTemplateMaster with fullscan;
    update statistics pdmlink.WfProxyTemplate with fullscan;
    update statistics pdmlink.WfRequesterActivity with fullscan;
    update statistics pdmlink.WfStateEventAudit with fullscan;
    update statistics pdmlink.WfSynchRobot with fullscan;
    update statistics pdmlink.WfSynchRobotTemplate with fullscan;
    update statistics pdmlink.WfTimerActivity with fullscan;
    update statistics pdmlink.WfTimerTemplate with fullscan;
    update statistics pdmlink.WfURLRobot with fullscan;
    update statistics pdmlink.WfURLRobotTemplate with fullscan;
    update statistics pdmlink.WfVotingEventAudit with fullscan;
    update statistics pdmlink.WorkflowPboActions with fullscan;
    update statistics pdmlink.WorkflowRecord with fullscan;
    update statistics pdmlink.WorkflowTaskTab with fullscan;
    update statistics pdmlink.WorkflowVariableEventInfo with fullscan;
    update statistics pdmlink.WorkItem with fullscan;
    update statistics pdmlink.WorkItemLink with fullscan;
    update statistics pdmlink.WorkPackage with fullscan;
    update statistics pdmlink.WorkPackageMaster with fullscan;
    update statistics pdmlink.WorkPackageMasterKey with fullscan;
    update statistics pdmlink.WorkPackageSequence with fullscan;
    update statistics pdmlink.WorkspaceMemberStatus with fullscan;
    update statistics pdmlink.WPSuccessorLink with fullscan;
    update statistics pdmlink.WPSyncBaseline with fullscan;
    update statistics pdmlink.WTAclEntry with fullscan;
    update statistics pdmlink.WTAnalysisActivity with fullscan;
    update statistics pdmlink.wtanalysisactivityid_seq with fullscan;
    update statistics pdmlink.WTAnalysisActivityMaster with fullscan;
    update statistics pdmlink.WTCalendar with fullscan;
    update statistics pdmlink.WTChangeActivity2 with fullscan;
    update statistics pdmlink.WTChangeActivity2Master with fullscan;
    update statistics pdmlink.wtchangeactivityid_seq with fullscan;
    update statistics pdmlink.WTChangeDirective with fullscan;
    update statistics pdmlink.WTChangeInvestigation with fullscan;
    update statistics pdmlink.wtchangeinvestigationid_seq with fullscan;
    update statistics pdmlink.WTChangeInvestigationMaster with fullscan;
    update statistics pdmlink.WTChangeIssue with fullscan;
    update statistics pdmlink.wtchangeissueid_seq with fullscan;
    update statistics pdmlink.WTChangeIssueMaster with fullscan;
    update statistics pdmlink.WTChangeOrder2 with fullscan;
    update statistics pdmlink.WTChangeOrder2Master with fullscan;
    update statistics pdmlink.wtchangeorderid_seq with fullscan;
    update statistics pdmlink.WTChangeProposal with fullscan;
    update statistics pdmlink.wtchangeproposalid_seq with fullscan;
    update statistics pdmlink.WTChangeProposalMaster with fullscan;
    update statistics pdmlink.WTChangeRequest2 with fullscan;
    update statistics pdmlink.WTChangeRequest2Master with fullscan;
    update statistics pdmlink.wtchangerequestid_seq with fullscan;
    update statistics pdmlink.WTChangeReview with fullscan;
    update statistics pdmlink.WTCHANGEREVIEWID_seq with fullscan;
    update statistics pdmlink.WTChangeReviewMaster with fullscan;
    update statistics pdmlink.WTContainerFilter with fullscan;
    update statistics pdmlink.WTContainerTemplateMaster with fullscan;
    update statistics pdmlink.WTDatedEffectivity with fullscan;
    update statistics pdmlink.WTDocument with fullscan;
    update statistics pdmlink.WTDocumentConfigSpec with fullscan;
    update statistics pdmlink.WTDocumentDependencyLink with fullscan;
    update statistics pdmlink.wtdocumentid_seq with fullscan;
    update statistics pdmlink.WTDocumentMaster with fullscan;
    update statistics pdmlink.WTDocumentMasterKey with fullscan;
    update statistics pdmlink.WTDocumentUsageLink with fullscan;
    update statistics pdmlink.WTGroup with fullscan;
    update statistics pdmlink.WTIncorporationDate with fullscan;
    update statistics pdmlink.wtkey_seq with fullscan;
    update statistics pdmlink.WTLibrary with fullscan;
    update statistics pdmlink.WTLotEffectivity with fullscan;
    update statistics pdmlink.WTMarkUp with fullscan;
    update statistics pdmlink.WTMarkUpBaseline with fullscan;
    update statistics pdmlink.WTMasterProcess with fullscan;
    update statistics pdmlink.WTMasterProcessTemplate with fullscan;
    update statistics pdmlink.WTMasterProcessToESITargetLink with fullscan;
    update statistics pdmlink.WTOrganization with fullscan;
    update statistics pdmlink.WTPart with fullscan;
    update statistics pdmlink.WTPartAlternateHistory with fullscan;
    update statistics pdmlink.WTPartAlternateLink with fullscan;
    update statistics pdmlink.WTPartAlternateRep with fullscan;
    update statistics pdmlink.WTPartAlternateRepIDSequence with fullscan;
    update statistics pdmlink.WTPartAlternateRepMaster with fullscan;
    update statistics pdmlink.WTPartAlternateRepMasterKey with fullscan;
    update statistics pdmlink.WTPartConfigSpec with fullscan;
    update statistics pdmlink.WTPartDescribeLink with fullscan;
    update statistics pdmlink.wtpartid_seq with fullscan;
    update statistics pdmlink.WTPartMaster with fullscan;
    update statistics pdmlink.WTPartMasterKey with fullscan;
    update statistics pdmlink.WTPartReferenceLink with fullscan;
    update statistics pdmlink.WTPartSubstituteLink with fullscan;
    update statistics pdmlink.WTPartUsageLink with fullscan;
    update statistics pdmlink.WTPIDescribeLink with fullscan;
    update statistics pdmlink.WTPIReferenceLink with fullscan;
    update statistics pdmlink.WTProcessStep with fullscan;
    update statistics pdmlink.WTProcessStepInstance with fullscan;
    update statistics pdmlink.WTProcessStepToProcessStepLink with fullscan;
    update statistics pdmlink.WTProductConfigMaster with fullscan;
    update statistics pdmlink.WTProductConfiguration with fullscan;
    update statistics pdmlink.WTProductInstance with fullscan;
    update statistics pdmlink.WTProductInstance2 with fullscan;
    update statistics pdmlink.WTProductInstanceMaster with fullscan;
    update statistics pdmlink.WTReservation with fullscan;
    update statistics pdmlink.WTRNRequest with fullscan;
    update statistics pdmlink.WTRolePrincipal with fullscan;
    update statistics pdmlink.WTSerialNumberedEffectivity with fullscan;
    update statistics pdmlink.WTTypeDefinition with fullscan;
    update statistics pdmlink.WTTypeDefinitionMaster with fullscan;
    update statistics pdmlink.WTUnit with fullscan;
    update statistics pdmlink.WTUnitMaster with fullscan;
    update statistics pdmlink.WTUnitMasterKey with fullscan;
    update statistics pdmlink.WtUpgInst_IncrementalUpdate with fullscan;
    update statistics pdmlink.WtUpgInst_Installation with fullscan;
    update statistics pdmlink.WtUpgInst_RepairTask with fullscan;
    update statistics pdmlink.WtUpgInst_UpgradePhase with fullscan;
    update statistics pdmlink.WtUpgInst_UpgradeTask with fullscan;
    update statistics pdmlink.WtUpgInst_UserProperties with fullscan;
    update statistics pdmlink.WtUpgInst_VersionedAssembly with fullscan;
    update statistics pdmlink.WTUser with fullscan;
    update statistics pdmlink.WTVariance with fullscan;
    update statistics pdmlink.wtvarianceid_seq with fullscan;
    update statistics pdmlink.WTVarianceMaster with fullscan;
    update statistics pdmlink.WTView with fullscan;
    update statistics pdmlink.WTWorkSet with fullscan;
    update statistics pdmlink.WTWorkSetComponentLink with fullscan;
    update statistics pdmlink.WTWorkSetMaster with fullscan;
    update statistics pdmlink.WTWorkSetMasterKey with fullscan;
    update statistics pdmlink.WTWorkSetReferenceLink with fullscan;
    update statistics pdmlink.WVSConfigurationTemplate with fullscan;
    update statistics pdmlink.XliffLink with fullscan;
    update statistics pdmlink.XMLDocument with fullscan;
    update statistics pdmlink.XMLRepoStatus with fullscan;
    update statistics pdmlink.TraditionalMeeting with fullscan;
    update statistics pdmlink.TransformFilterEntry with fullscan;
    update statistics pdmlink.TranslationDictionary with fullscan;
    update statistics pdmlink.TranslationDictionaryEntry with fullscan;
    update statistics pdmlink.TranslationLink with fullscan;
    update statistics pdmlink.TranslationMasterLink with fullscan;
    update statistics pdmlink.TransparentInbox with fullscan;
    update statistics pdmlink.TransparentOutbox with fullscan;
    update statistics pdmlink.TypeBasedRule with fullscan;
    update statistics pdmlink.TypeContainerConstraint with fullscan;
    update statistics pdmlink.TypedIteratedResource with fullscan;
    update statistics pdmlink.TypedIteratedResourceMaster with fullscan;
    update statistics pdmlink.TypeFilter with fullscan;
    update statistics pdmlink.TypeSingleAttrConstraint with fullscan;
    update statistics pdmlink.UfidMapping with fullscan;
    update statistics pdmlink.UIAccess with fullscan;
    update statistics pdmlink.UnitDefinition with fullscan;
    update statistics pdmlink.UnitExportRecord with fullscan;
    update statistics pdmlink.UnitImportRecord with fullscan;
    update statistics pdmlink.UnitReceiveRecord with fullscan;
    update statistics pdmlink.UnitSeedLink with fullscan;
    update statistics pdmlink.UnitSendRecord with fullscan;
    update statistics pdmlink.UnitValue with fullscan;
    update statistics pdmlink.UploadedContentData with fullscan;
    update statistics pdmlink.UploadStatus with fullscan;
    update statistics pdmlink.URLData with fullscan;
    update statistics pdmlink.URLDefinition with fullscan;
    update statistics pdmlink.URLValue with fullscan;
    update statistics pdmlink.UserAgentInfo with fullscan;
    update statistics pdmlink.UserElectronicIDLink with fullscan;
    update statistics pdmlink.UserSessionEventInfo with fullscan;
    update statistics pdmlink.UsesOccurrenceDocumentation with fullscan;
    update statistics pdmlink.UsesOccurrenceUserIBAs with fullscan;
    update statistics pdmlink.VarianceBlockEffectivity with fullscan;
    update statistics pdmlink.VarianceDateEffectivity with fullscan;
    update statistics pdmlink.VarianceLNEffectivity with fullscan;
    update statistics pdmlink.VarianceMSNEffectivity with fullscan;
    update statistics pdmlink.VarianceSNEffectivity with fullscan;
    update statistics pdmlink.VariantNameSeq with fullscan;
    update statistics pdmlink.VariantSpec with fullscan;
    update statistics pdmlink.variantspecid_seq with fullscan;
    update statistics pdmlink.VariantSpecMaster with fullscan;
    update statistics pdmlink.VariantSpecMasterKey with fullscan;
    update statistics pdmlink.VariantSpecVariantLink with fullscan;
    update statistics pdmlink.VariantsQueueEntryInfo with fullscan;
    update statistics pdmlink.VaultCleanupAuditLogs with fullscan;
    update statistics pdmlink.VersionEventInfo with fullscan;
    update statistics pdmlink.ViewAssociation with fullscan;
    update statistics pdmlink.ViewRepresentationsEventInfo with fullscan;
    update statistics pdmlink.VSEDViewFilter with fullscan;
    update statistics pdmlink.WAReportConfiguration with fullscan;
    update statistics pdmlink.WCTK_AHF_EPMFTValPK_Errs with fullscan;
    update statistics pdmlink.WfAdHocActivity with fullscan;
    update statistics pdmlink.WfAdHocActivityTemplate with fullscan;
    update statistics pdmlink.WfApplicationRobot with fullscan;
    update statistics pdmlink.WfApplRobotTemplate with fullscan;
    update statistics pdmlink.WfAssignedActivity with fullscan;
    update statistics pdmlink.WfAssignedActivityTemplate with fullscan;
    update statistics pdmlink.WfAssignment with fullscan;
    update statistics pdmlink.WfAssignmentEventAudit with fullscan;
    update statistics pdmlink.WfBallot with fullscan;
    update statistics pdmlink.WfBlock with fullscan;
    update statistics pdmlink.WfBlockTemplate with fullscan;
    update statistics pdmlink.WfBookmark with fullscan;
    update statistics pdmlink.WfConnector with fullscan;
    update statistics pdmlink.WfConnectorTemplate with fullscan;
    update statistics pdmlink.WfCreateProcessEventAudit with fullscan;
    update statistics pdmlink.WfDataEventAudit with fullscan;
    update statistics pdmlink.WfExceptionEventAudit with fullscan;
    update statistics pdmlink.WfExpression with fullscan;
    update statistics pdmlink.WfExpressionRobot with fullscan;
    update statistics pdmlink.WfExprRobotTemplate with fullscan;
    update statistics pdmlink.WfExternalMethod with fullscan;
    update statistics pdmlink.WfExternalMethodTemplate with fullscan;
    update statistics pdmlink.WfFolderedBookmark with fullscan;
    update statistics pdmlink.WfInternalMethod with fullscan;
    update statistics pdmlink.WfInternalMethodTemplate with fullscan;
    update statistics pdmlink.WfProcess with fullscan;
    update statistics pdmlink.WfProcessRequester with fullscan;
    update statistics pdmlink.WfProcessTemplate with fullscan;
    update statistics pdmlink.WfProcessTemplateMaster with fullscan;
    update statistics pdmlink.WfProxyTemplate with fullscan;
    update statistics pdmlink.WfRequesterActivity with fullscan;
    update statistics pdmlink.WfStateEventAudit with fullscan;
    update statistics pdmlink.WfSynchRobot with fullscan;
    update statistics pdmlink.WfSynchRobotTemplate with fullscan;
    update statistics pdmlink.WfTimerActivity with fullscan;
    update statistics pdmlink.WfTimerTemplate with fullscan;
    update statistics pdmlink.WfURLRobot with fullscan;
    update statistics pdmlink.WfURLRobotTemplate with fullscan;
    update statistics pdmlink.WfVotingEventAudit with fullscan;
    update statistics pdmlink.WorkflowPboActions with fullscan;
    update statistics pdmlink.WorkflowRecord with fullscan;
    update statistics pdmlink.WorkflowTaskTab with fullscan;
    update statistics pdmlink.WorkflowVariableEventInfo with fullscan;
    update statistics pdmlink.WorkItem with fullscan;
    update statistics pdmlink.WorkItemLink with fullscan;
    update statistics pdmlink.WorkPackage with fullscan;
    update statistics pdmlink.WorkPackageMaster with fullscan;
    update statistics pdmlink.WorkPackageMasterKey with fullscan;
    update statistics pdmlink.WorkPackageSequence with fullscan;
    update statistics pdmlink.WorkspaceMemberStatus with fullscan;
    update statistics pdmlink.WPSuccessorLink with fullscan;
    update statistics pdmlink.WPSyncBaseline with fullscan;
    update statistics pdmlink.WTAclEntry with fullscan;
    update statistics pdmlink.WTAnalysisActivity with fullscan;
    update statistics pdmlink.wtanalysisactivityid_seq with fullscan;
    update statistics pdmlink.WTAnalysisActivityMaster with fullscan;
    update statistics pdmlink.WTCalendar with fullscan;
    update statistics pdmlink.WTChangeActivity2 with fullscan;
    update statistics pdmlink.WTChangeActivity2Master with fullscan;
    update statistics pdmlink.wtchangeactivityid_seq with fullscan;
    update statistics pdmlink.WTChangeDirective with fullscan;
    update statistics pdmlink.WTChangeInvestigation with fullscan;
    update statistics pdmlink.wtchangeinvestigationid_seq with fullscan;
    update statistics pdmlink.WTChangeInvestigationMaster with fullscan;
    update statistics pdmlink.WTChangeIssue with fullscan;
    update statistics pdmlink.wtchangeissueid_seq with fullscan;
    update statistics pdmlink.WTChangeIssueMaster with fullscan;
    update statistics pdmlink.WTChangeOrder2 with fullscan;
    update statistics pdmlink.WTChangeOrder2Master with fullscan;
    update statistics pdmlink.wtchangeorderid_seq with fullscan;
    update statistics pdmlink.WTChangeProposal with fullscan;
    update statistics pdmlink.wtchangeproposalid_seq with fullscan;
    update statistics pdmlink.WTChangeProposalMaster with fullscan;
    update statistics pdmlink.WTChangeRequest2 with fullscan;
    update statistics pdmlink.WTChangeRequest2Master with fullscan;
    update statistics pdmlink.wtchangerequestid_seq with fullscan;
    update statistics pdmlink.WTChangeReview with fullscan;
    update statistics pdmlink.WTCHANGEREVIEWID_seq with fullscan;
    update statistics pdmlink.WTChangeReviewMaster with fullscan;
    update statistics pdmlink.WTContainerFilter with fullscan;
    update statistics pdmlink.WTContainerTemplateMaster with fullscan;
    update statistics pdmlink.WTDatedEffectivity with fullscan;
    update statistics pdmlink.WTDocument with fullscan;
    update statistics pdmlink.WTDocumentConfigSpec with fullscan;
    update statistics pdmlink.WTDocumentDependencyLink with fullscan;
    update statistics pdmlink.wtdocumentid_seq with fullscan;
    update statistics pdmlink.WTDocumentMaster with fullscan;
    update statistics pdmlink.WTDocumentMasterKey with fullscan;
    update statistics pdmlink.WTDocumentUsageLink with fullscan;
    update statistics pdmlink.WTGroup with fullscan;
    update statistics pdmlink.WTIncorporationDate with fullscan;
    update statistics pdmlink.wtkey_seq with fullscan;
    update statistics pdmlink.WTLibrary with fullscan;
    update statistics pdmlink.WTLotEffectivity with fullscan;
    update statistics pdmlink.WTMarkUp with fullscan;
    update statistics pdmlink.WTMarkUpBaseline with fullscan;
    update statistics pdmlink.WTMasterProcess with fullscan;
    update statistics pdmlink.WTMasterProcessTemplate with fullscan;
    update statistics pdmlink.WTMasterProcessToESITargetLink with fullscan;
    update statistics pdmlink.WTOrganization with fullscan;
    update statistics pdmlink.WTPart with fullscan;
    update statistics pdmlink.WTPartAlternateHistory with fullscan;
    update statistics pdmlink.WTPartAlternateLink with fullscan;
    update statistics pdmlink.WTPartAlternateRep with fullscan;
    update statistics pdmlink.WTPartAlternateRepIDSequence with fullscan;
    update statistics pdmlink.WTPartAlternateRepMaster with fullscan;
    update statistics pdmlink.WTPartAlternateRepMasterKey with fullscan;
    update statistics pdmlink.WTPartConfigSpec with fullscan;
    update statistics pdmlink.WTPartDescribeLink with fullscan;
    update statistics pdmlink.wtpartid_seq with fullscan;
    update statistics pdmlink.WTPartMaster with fullscan;
    update statistics pdmlink.WTPartMasterKey with fullscan;
    update statistics pdmlink.WTPartReferenceLink with fullscan;
    update statistics pdmlink.WTPartSubstituteLink with fullscan;
    update statistics pdmlink.WTPartUsageLink with fullscan;
    update statistics pdmlink.WTPIDescribeLink with fullscan;
    update statistics pdmlink.WTPIReferenceLink with fullscan;
    update statistics pdmlink.WTProcessStep with fullscan;
    update statistics pdmlink.WTProcessStepInstance with fullscan;
    update statistics pdmlink.WTProcessStepToProcessStepLink with fullscan;
    update statistics pdmlink.WTProductConfigMaster with fullscan;
    update statistics pdmlink.WTProductConfiguration with fullscan;
    update statistics pdmlink.WTProductInstance with fullscan;
    update statistics pdmlink.WTProductInstance2 with fullscan;
    update statistics pdmlink.WTProductInstanceMaster with fullscan;
    update statistics pdmlink.WTReservation with fullscan;
    update statistics pdmlink.WTRNRequest with fullscan;
    update statistics pdmlink.WTRolePrincipal with fullscan;
    update statistics pdmlink.WTSerialNumberedEffectivity with fullscan;
    update statistics pdmlink.WTTypeDefinition with fullscan;
    update statistics pdmlink.WTTypeDefinitionMaster with fullscan;
    update statistics pdmlink.WTUnit with fullscan;
    update statistics pdmlink.WTUnitMaster with fullscan;
    update statistics pdmlink.WTUnitMasterKey with fullscan;
    update statistics pdmlink.WtUpgInst_IncrementalUpdate with fullscan;
    update statistics pdmlink.WtUpgInst_Installation with fullscan;
    update statistics pdmlink.WtUpgInst_RepairTask with fullscan;
    update statistics pdmlink.WtUpgInst_UpgradePhase with fullscan;
    update statistics pdmlink.WtUpgInst_UpgradeTask with fullscan;
    update statistics pdmlink.WtUpgInst_UserProperties with fullscan;
    update statistics pdmlink.WtUpgInst_VersionedAssembly with fullscan;
    update statistics pdmlink.WTUser with fullscan;
    update statistics pdmlink.WTVariance with fullscan;
    update statistics pdmlink.wtvarianceid_seq with fullscan;
    update statistics pdmlink.WTVarianceMaster with fullscan;
    update statistics pdmlink.WTView with fullscan;
    update statistics pdmlink.WTWorkSet with fullscan;
    update statistics pdmlink.WTWorkSetComponentLink with fullscan;
    update statistics pdmlink.WTWorkSetMaster with fullscan;
    update statistics pdmlink.WTWorkSetMasterKey with fullscan;
    update statistics pdmlink.WTWorkSetReferenceLink with fullscan;
    update statistics pdmlink.WVSConfigurationTemplate with fullscan;
    update statistics pdmlink.XliffLink with fullscan;
    update statistics pdmlink.XMLDocument with fullscan;
    update statistics pdmlink.XMLRepoStatus with fullscan;
    update statistics pdmlink.XpathCondition with fullscan;
    update statistics pdmlink.Xpaths with fullscan;

    Note! This command are configured for run on a database instance named pdmlink, so if the name on the database windchill, then the command should be updated accordingly...

  5. Schedule the job by pressing New and choose name and what time to execute, then press OK and OK

  6. The new job is now listed under the SQL Server Agent: