5. Regular tables have stats calculated in order to help the optimizer (which may be good or bad). GTTs don't have stats calculated unless they are specifically set.
If we set optimizer_dynamic_sampling parameter correctly, then oracle calculates the stats during query parse time in 9i/10g.

Tamil