Teradata R Package Function Reference - db_analyze - Teradata R Package - Look here for syntax, methods and examples for the functions included in the Teradata R Package.

Teradata® R Package Function Reference

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2020-02-28
dita:id
B700-4007
lifecycle
previous
Product Category
Teradata Vantage

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.

column

Required Argument. Specifies name of the remote table column(s). Column name is required to collect the statistics in Teradata. This argument allows multiple columns as a vector.

...

Other parameters passed to methods.

Value

Returns 2 on successful, error on any failure.

See Also

db_begin(),db_commit(),db_rollback()

Examples

con <- td_get_context()$connection
iris2 <-  copy_to(con, iris, overwrite = FALSE)
db_analyze(con, "iris", "Sepal.Length")