createExtraIndices: Create Optional Extra Indices for ETL Performance

In OHDSI/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

Create Optional Extra Indices for ETL Performance

Description

This function creates indices for certain tables which may help to speed up LoadEventTables.

Usage

CreateExtraIndices(
  connectionDetails,
  cdmSchema,
  syntheaSchema,
  syntheaVersion,
  outputFolder = NULL,
  sqlOnly = FALSE
)

Arguments

connectionDetails	An R object of type connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.
cdmSchema	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'.
syntheaSchema	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'.
syntheaVersion	Your Synthea version. Currently "2.7.0", "3.0.0", "3.1.0", "3.2.0" and "3.3.0" are supported.
outputFolder	Location of the SQL scripts if sqlOnly = TRUE. Default is NULL.
sqlOnly	A boolean that determines whether to create the indices or generate a SQL scripts. Default is FALSE.

Details

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, 3.2.0 and 3.3.0) .

OHDSI/ETL-Synthea documentation built on Feb. 24, 2025, 3:48 a.m.