Problem:

How can I show the cardinality of a table using ODBCtest?

Resolution:

Bring up ODBCtest and do a FULL CONNECT using the DSN of the Relatiivty catalog. Enter userID and password, if they exist.

From the menu bar use Catalog->SQLStatistics and enter the TableName information, and set Unique=SQL_INDEX_ALL=1  (1.0).

After the SQLStatistics displays succesfully, select Results->GetDataAll from the menu bar to get something like this:

Get Data All:

"TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "NON_UNIQUE", "INDEX_QUALIFIER", "INDEX_NAME", "TYPE", "SEQ_IN_INDEX", "COLUMN_NAME", "COLLATION", "CARDINALITY", "PAGES", "FILTER_CONDITION"

plus the values.

See also: RelClientTest