BESCHREIBUNG
Die Indizes der SQL Server Tabellen sind entscheidend für die Abfrage Geschwindigkeit. Es kann vorkommen, dass die Indizes nicht mehr optimal sind und sich die Antwortzeiten dadurch verschlechtern.
SQL BEFEHLE ZUM RESTAURIEREN DER INDIZES
Sie müssen in einem Abfragefenster oder OSQL Fenster auf der TimeSafe Leistungserfassungs-Datenbank ausgeführt werden!
ACHTUNG: Die nachfolgenden Befehle sind nur für die aktuelle TimeSafe-Version gültig. Bei älteren Versionen kann es sein, dass einige Tabellen noch nicht vorhanden sind.
ALTER INDEX ALL ON tInvCurFactors REBUILD
ALTER INDEX ALL ON tLanguages REBUILD
ALTER INDEX ALL ON tSettings REBUILD
ALTER INDEX ALL ON Aktivitaetstyp REBUILD
ALTER INDEX ALL ON tLicenseKey REBUILD
ALTER INDEX ALL ON tToolsLoaded REBUILD
ALTER INDEX ALL ON Aktivitaetsschritt REBUILD
ALTER INDEX ALL ON tContacts REBUILD
ALTER INDEX ALL ON tTools REBUILD
ALTER INDEX ALL ON tMasterTaxKeys REBUILD
ALTER INDEX ALL ON tMasterTextTemplates REBUILD
ALTER INDEX ALL ON Datensicht REBUILD
ALTER INDEX ALL ON tMasterInvConditions REBUILD
ALTER INDEX ALL ON tMasterCurrencies REBUILD
ALTER INDEX ALL ON Dokument REBUILD
ALTER INDEX ALL ON tMasterPubHolidays REBUILD
ALTER INDEX ALL ON tMasterAccounts REBUILD
ALTER INDEX ALL ON tMasterMaterials REBUILD
ALTER INDEX ALL ON tMasterExpenses REBUILD
ALTER INDEX ALL ON tLumpSums REBUILD
ALTER INDEX ALL ON tMasterInvoiceState REBUILD
ALTER INDEX ALL ON tFeeTasks REBUILD
ALTER INDEX ALL ON tInvoices REBUILD
ALTER INDEX ALL ON tProjectTeam REBUILD
ALTER INDEX ALL ON tStructures REBUILD
ALTER INDEX ALL ON tExpenseServices REBUILD
ALTER INDEX ALL ON tIntHourlyRate REBUILD
ALTER INDEX ALL ON tMaterialServices REBUILD
ALTER INDEX ALL ON tCostCenter REBUILD
ALTER INDEX ALL ON tTimeServices REBUILD
ALTER INDEX ALL ON tProjectType REBUILD
ALTER INDEX ALL ON tOrganizations REBUILD
ALTER INDEX ALL ON tCostUnit REBUILD
ALTER INDEX ALL ON tAccPayments REBUILD
ALTER INDEX ALL ON tMasterActivities REBUILD
ALTER INDEX ALL ON tProjectDocuments REBUILD
ALTER INDEX ALL ON tActivities REBUILD
ALTER INDEX ALL ON tBookings REBUILD
ALTER INDEX ALL ON tBookingsLog REBUILD
ALTER INDEX ALL ON tEmployment REBUILD
ALTER INDEX ALL ON tDepartment REBUILD
ALTER INDEX ALL ON tTasks REBUILD
ALTER INDEX ALL ON BerichtsDefinition REBUILD
ALTER INDEX ALL ON tAuthorisationGroup REBUILD
ALTER INDEX ALL ON tCreditBalanceCorrections REBUILD
ALTER INDEX ALL ON tScale REBUILD
ALTER INDEX ALL ON tProjects REBUILD
ALTER INDEX ALL ON tEmployees REBUILD
ALTER INDEX ALL ON Attribut REBUILD
ALTER INDEX ALL ON tInvoiceRptDefinition REBUILD
ALTER INDEX ALL ON AttributAuswahlListeElement REBUILD
ALTER INDEX ALL ON tPrinter REBUILD
ALTER INDEX ALL ON AttributWert REBUILD
ALTER INDEX ALL ON tInvoiceRptFile REBUILD
ALTER INDEX ALL ON tTimeSrvRpt REBUILD
ALTER INDEX ALL ON tExpenseSrvRpt REBUILD
ALTER INDEX ALL ON tMaterialSrvRpt REBUILD
ALTER INDEX ALL ON Feiertagskalender REBUILD
ALTER INDEX ALL ON FIBUSchnittstelle REBUILD
ALTER INDEX ALL ON ESRDefinition REBUILD
ALTER INDEX ALL ON tPayments REBUILD
ALTER INDEX ALL ON MandantEinstellung REBUILD
ALTER INDEX ALL ON tFees REBUILD
ALTER INDEX ALL ON tScheduledItem REBUILD
ALTER INDEX ALL ON tFavorites REBUILD
ALTER INDEX ALL ON ERechnungsdefinition REBUILD
ALTER INDEX ALL ON tTaxKeyValidities REBUILD
ALTER INDEX ALL ON Verbindungstyp REBUILD
ALTER INDEX ALL ON Verbindung REBUILD
UPDATE STATISTICS tInvCurFactors
UPDATE STATISTICS tLanguages
UPDATE STATISTICS tSettings
UPDATE STATISTICS Aktivitaetstyp
UPDATE STATISTICS tLicenseKey
UPDATE STATISTICS tToolsLoaded
UPDATE STATISTICS Aktivitaetsschritt
UPDATE STATISTICS tContacts
UPDATE STATISTICS tTools
UPDATE STATISTICS tMasterTaxKeys
UPDATE STATISTICS tMasterTextTemplates
UPDATE STATISTICS Datensicht
UPDATE STATISTICS tMasterInvConditions
UPDATE STATISTICS tMasterCurrencies
UPDATE STATISTICS Dokument
UPDATE STATISTICS tMasterPubHolidays
UPDATE STATISTICS tMasterAccounts
UPDATE STATISTICS tMasterMaterials
UPDATE STATISTICS tMasterExpenses
UPDATE STATISTICS tLumpSums
UPDATE STATISTICS tMasterInvoiceState
UPDATE STATISTICS tFeeTasks
UPDATE STATISTICS tInvoices
UPDATE STATISTICS tProjectTeam
UPDATE STATISTICS tStructures
UPDATE STATISTICS tExpenseServices
UPDATE STATISTICS tIntHourlyRate
UPDATE STATISTICS tMaterialServices
UPDATE STATISTICS tCostCenter
UPDATE STATISTICS tTimeServices
UPDATE STATISTICS tProjectType
UPDATE STATISTICS tOrganizations
UPDATE STATISTICS tCostUnit
UPDATE STATISTICS tAccPayments
UPDATE STATISTICS tMasterActivities
UPDATE STATISTICS tProjectDocuments
UPDATE STATISTICS tActivities
UPDATE STATISTICS tBookings
UPDATE STATISTICS tBookingsLog
UPDATE STATISTICS tEmployment
UPDATE STATISTICS tDepartment
UPDATE STATISTICS tTasks
UPDATE STATISTICS BerichtsDefinition
UPDATE STATISTICS tAuthorisationGroup
UPDATE STATISTICS tCreditBalanceCorrections
UPDATE STATISTICS tScale
UPDATE STATISTICS tProjects
UPDATE STATISTICS tEmployees
UPDATE STATISTICS Attribut
UPDATE STATISTICS tInvoiceRptDefinition
UPDATE STATISTICS AttributAuswahlListeElement
UPDATE STATISTICS tPrinter
UPDATE STATISTICS AttributWert
UPDATE STATISTICS tInvoiceRptFile
UPDATE STATISTICS tTimeSrvRpt
UPDATE STATISTICS tExpenseSrvRpt
UPDATE STATISTICS tMaterialSrvRpt
UPDATE STATISTICS Feiertagskalender
UPDATE STATISTICS FIBUSchnittstelle
UPDATE STATISTICS ESRDefinition
UPDATE STATISTICS tPayments
UPDATE STATISTICS MandantEinstellung
UPDATE STATISTICS tFees
UPDATE STATISTICS tScheduledItem
UPDATE STATISTICS tFavorites
UPDATE STATISTICS ERechnungsdefinition
UPDATE STATISTICS tTaxKeyValidities
UPDATE STATISTICS Verbindungstyp
UPDATE STATISTICS VerbindungCODE ZUM GENERIEREN DER BEFEHLE
select 'ALTER INDEX ALL ON ' + name + ' REBUILD ' from sysobjects where Type = 'U' AND name NOT LIKE '%dtproperties%' select 'UPDATE STATISTICS ' + name + ' ' from sysobjects where Type = 'U' AND name NOT LIKE '%dtproperties%'
