Achilles (version 1.5)

createIndices: Create indices on Achilles results tables and concept hierarchy

Description

createIndices executes script to create indicies on the Achilles tables.

Usage

createIndices(connectionDetails, resultsDatabaseSchema,
  oracleTempSchema = resultsDatabaseSchema, cdmVersion = "5")

Arguments

connectionDetails

An R object of type ConnectionDetail (details for the function that contains server info, database type, optionally username/password, port)

resultsDatabaseSchema

string name of database schema that holds the results tables for indexing. On SQL Server, this should specifiy both the database and the schema, so for example 'results.dbo'.

oracleTempSchema

For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.

cdmVersion

Define the OMOP CDM version used: currently support only "5". Default = "5"

Value

nothing is returned

Details

createIndices executes script to create indicies on the Achilles tables.

Examples

# NOT RUN {
  connectionDetails <- DatabaseConnector::createConnectionDetails(dbms="sql server", server="myserver")
  createIndices <- createIndices(connectionDetails, resultsDatabaseSchema="scratch")
# }