PHP Manual
Prev |  | Next

# odbc_statistics

(PHP 4, PHP 5)

odbc_statistics -- Retrieve statistics about a table

## 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.

Prev | Home | Next
odbc_specialcolumns | Up | odbc_tableprivileges