Database Statistics › Package Detail › Methods › Method: SET_STATS_RLS

Previous Topic: Method: DELETE_GTT_STATS

Next Topic: Method: LOCK_STATS

Method: SET_STATS_RLS

Sets user-defined statistics on selected columns in TMP_Wgn3AddRLS and Wgn3EventParticpant. This is to overcome some poor cardinality estimates that have been found in the past when joining these two tables.

PROCEDURE Set_Stats_RLS (p_StatType IN NUMBER DEFAULT NULL );

The argument p_StatType defines which tables to set the user-defined statistics on:

NULL Both tables (default)

1 Wgn3EventParticpant only

2 TMP_Wgn3AddRLS only