createIndices: Create indicies

In EHDEN/CatalogueExport: Exports Descriptive Statistics Summary for the EHDEN Database Catalogue

Description

Create indicies

Usage

createIndices(
  connectionDetails,
  resultsDatabaseSchema,
  outputFolder,
  sqlOnly = FALSE,
  verboseMode = TRUE,
  catalogueTables = c("catalogue_results", "catalogue_results_dist")
)

Arguments

connectionDetails	An R object of type connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.
resultsDatabaseSchema	Fully qualified name of database schema that we can write final results to. Default is cdmDatabaseSchema. On SQL Server, this should specifiy both the database and the schema, so for example, on SQL Server, 'cdm_results.dbo'.
outputFolder	Path to store logs and SQL files
sqlOnly	TRUE = just generate SQL files, don't actually run, FALSE = run Achilles
verboseMode	Boolean to determine if the console will show all execution steps. Default = TRUE
catalogueTables	Which CatalogueExport tables should be indexed? Default is both catalogue_results and catalogue_results_dist.

Details

Post-processing, create indices to help performance. Cannot be used with Redshift.

EHDEN/CatalogueExport documentation built on April 2, 2021, 5:13 p.m.