Teradata Package for R Function Reference | 17.00 - 17.00 - db_analyze - Teradata Package for R

Teradata® Package for R Function Reference

prodname
Teradata Package for R
vrm_release
17.00
created_date
July 2021
category
Programming Reference
featnum
B700-4007-090K

Description

This function collects the statistics of the given table.

Usage

## S3 method for class 'Teradata'
db_analyze(con, table, column, ...)

Arguments

con

Required Argument.
Specifies remote data source.

table

Required Argument.
Specifies remote table name.
Types: character

column

Required Argument.
Specifies name of the remote table column(s). Column name is required to collect the statistics in Teradata.
Types: character OR vector of characters

...

Other parameters passed to methods.

Value

Returns 2 on success.

See Also

db_begin, db_commit, db_rollback, sql_table_analyze

Examples

# Get the connection.
con <- td_get_context()$connection

# Load the data.frame 'iris' to "iris" table.
iris2 <- copy_to(con, iris, overwrite = FALSE)

# Analyze the table "iris".
db_analyze(con, "iris", "Sepal.Length")