I hope I got this right, you want to know how analyze and dbms_stat works?
ANALYZE TABLE <table_name> compute statistics
EXEC DBMS_STATS.GATHER_TABLE_STATS ('hr', 'employees')... where hr is ownname (schema) and employees is the tablename.... should make use of this though
Edited by: missymichi on Feb 4, 2013 10:44 PM
Edited by: missymichi on Feb 4, 2013 11:37 PM