db2_statistics

db2_statistics

Returns a result set listing the index and statistics for a table

resource **db2_statistics** resource $connection  $qualifier  $schema string $table_name bool $unique

Returns a result set listing the index and statistics for a table.

connectionA valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

qualifierA qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass null or an empty string.

schemaThe schema that contains the targeted table. If this parameter is null, the statistics and indexes are returned for the schema of the current user.

table_nameThe name of the table.

unique When is true, the information for all indexes in the table are returned. Otherwise, only the information for unique indexes in the table are returned. unique

Returns a statement resource with a result set containing rows describing the statistics and indexes for the base tables matching the specified parameters. The rows are composed of the following columns:

db2_column_privileges``db2_columns``db2_foreign_keys``db2_primary_keys``db2_procedure_columns``db2_procedures``db2_special_columns``db2_table_privileges``db2_tables