createExtraIndices.Rd
This function creates indices for certain tables which may help to speed up LoadEventTables.
CreateExtraIndices(
connectionDetails,
cdmSchema,
syntheaSchema,
syntheaVersion,
outputFolder = NULL,
sqlOnly = FALSE
)
An R object of typeconnectionDetails
created using the
function createConnectionDetails
in the DatabaseConnector
package.
The name of the CDM database schema. Requires read and write permissions to this schema. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.
The name of the Synthea database schema. Requires read and write permissions to this schema. On SQL Server, this should specify both the database and the schema, so for example 'synthea.dbo'.
Your Synthea version. Currently "2.7.0", "3.0.0", "3.1.0" and "3.2.0" are supported.
Location of the SQL scripts if sqlOnly = TRUE. Default is NULL.
A boolean that determines whether to create the indices or generate a SQL scripts. Default is FALSE.
This function creates indices which have been found to speed up certain long-running INSERT queries in LoadEventTables, for some users. Indices are created on the intermediate vocabulary mapping tables; the person & provider CDM tables; and the claims_transactions Synthea table (in Synthea 3.0.0, 3.1.0 and 3.2.0) .