Description

resource odbc_statistics ( resource connection_id, string qualifier, string owner, string table_name, int unique, int accuracy )

Get statistics about a table and its indexes. Returns an ODBC result identifier or FALSE on failure.

The result set has the following columns:

• TABLE_QUALIFIER

• TABLE_OWNER

• TABLE_NAME

• NON_UNIQUE

• INDEX_QUALIFIER

• INDEX_NAME

• TYPE

• SEQ_IN_INDEX

• COLUMN_NAME

• COLLATION

• CARDINALITY

• PAGES

• FILTER_CONDITION

The result set is ordered by NON_UNIQUE, TYPE, INDEX_QUALIFIER, INDEX_NAME and SEQ_IN_INDEX.