fnd_stats or dbms_stats
I have one doubt.
We have oracle apps database. Usually we used to run fnd_stats on seeded oracle apps tables like (gl_ge_lines,oe_order_lines_all etc.). and dbms_stats on custom tables. Suppose, i copied seeded apps tables via CTAS or imp/exp into custom schema.
so, what i have to run, fnd_stats or dbms_stats? if fnd_stats, then how oracle apps decide on data? If dbms_stats why?
What will be the impact if run fnd_stats on custom table which is created.
This is doubt which i want to clear.