Sets user-defined statistics on selected columns in TMP_Wgn3AddRLS and Wgn3EventParticipant. 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 Wgn3EventParticipant only
2 TMP_Wgn3AddRLS only
|
Copyright © 2014 CA.
All rights reserved.
|
|