SAP ABAP Function Module RSDU_ANALYZE_TABLE_SYB (Create statistics for Cost-Based Optimizer for the specified tables)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-SYS-DB-SYB (Application Component) BW on Sybase ASE Database Platform
⤷
RSSYB (Package) SAP BW on Sybase ASE
⤷
⤷
Basic Data
| Function Module | RSDU_ANALYZE_TABLE_SYB | Create statistics for Cost-Based Optimizer for the specified tables |
| Function Group | RSDU_UTIL_SYB | Data Manager General Utilities 1 |
| Program Name | SAPLRSDU_UTIL_SYB | |
| INCLUDE Name | LRSDU_UTIL_SYBU10 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
| |
C_PROCESSED | TYPE | RS_BOOL | RS_C_FALSE | Boolean | ||
| |
I_T_TABLNM | TYPE | RSDU_T_TABLNM | Tables to Be Analyzed | |||
| |
I_TABLNM | TYPE | RSD_TABLNM | Table to Be Analyzed | |||
| |
I_PERCENTAGE | TYPE | I | 10 | Percentage for ESTIMATE Clause | ||
| |
I_TEMP_TABLE | TYPE | RS_BOOL | RS_C_FALSE | True = Table is Temporary | ||
| |
I_FORCE_ESTIMATE | TYPE | RS_BOOL | RS_C_FALSE | True = Do not Compute Statistics, If Possible | ||
| |
I_PERCENTAGE_SPECIFIED | TYPE | RS_BOOL | ||||
| |
I_FORCE_STATISTICS | TYPE | RS_BOOL | RS_C_FALSE | |||
| |
I_CONNECTION | TYPE | DBCON_NAME | 'R/3*' | |||
| |
I_ALL_COLUMNS | TYPE | RS_BOOL | RS_C_FALSE | All Columns (Not Just Indexed) | ||
| |
ANALYZE_FAILED | TYPE | ANALYZE Failed | ||||
Processing Type
| Normal Function Module | |
| |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20110909 |
| SAP Release Created in | 731 |