| SE_table_update_dbms_stats | |
Updates the DBMS statistics on a table.
LONG SE_table_update_dbms_stats
(SE_CONNECTION connection,
const CHAR *table,
const CHAR *index,
const CHAR *mode,
const LONG keyword);
| connection | The connection handle |
| table | The DBMS table name |
| index | The DBMS index name |
| mode | The statistics mode |
| keyword |
The keyword is entered as a bit-mask specifing the table or tables
whose statistics are to be updated. The keyword bit-mask can be entered
as single bit-mask or an 'ORed'combination of bit-masks from the following
list: SE_UPDATE_ADDS_TABLE_STATS SE_UPDATE_DELETES_TABLE_STATS SE_UPDATE_FEATURE_TABLE_STATS SE_UPDATE_BUSINESS_TABLE_STATS SE_UPDATE_RASTER_TABLE_STATS SE_UPDATE_ALL_TABLE_STATS |
SE_table_update_dbms_stats updates the DBMS statistics on the specified
table. If the table is a layer, statistics are generated for all related
layer objects including indexes unless a table keyword is specifed. When
a table keyword is provided, statistics is calculated for that table and
its indexes.
The mode values for Oracle are:
COMPUTE
ESTIMATE
The mode values for Informix are:
LOW
MEDIUM
HIGH
DISTRIBUTIONS
DROP
RESOLUTION
SPECIFIC
ROUTINE
FUNCTION
PROCEDURE
The mode values for SQLServer are:
with fullscan [index]
with sample %% percent [index]
The mode values for DB2 are:
NULL (The DB2 mode implementation has been fixed at
"with distributions and detailed indexes all" for all tables)
SE_SUCCESS
SE_DB_IO_ERROR
SE_INVALID_CONNECTION
SE_INDVALID_PARAM_VALUE
SE_INDEX_NOEXIST
SE_NET_FAILURE
SE_NO_PERMISSIONS
SE_SDE_NOT_STARTED
SE_TABLE_NOEXIST