Histograms on dynamic sampled GTT?

Hi all

I'm on a 11.2.0.3 SE database, and I'm dealing with data collections.

I have a -- potentially huge -- source table (aka tab_A) which I'm transfering piecewise in a target table (aka tab_B) (afterwards there are other operations performed using tab_B)

• Both tables are GTTs.
• Source tab_A has an indexed numeric column (a non-unique Btree) to determine whether the occurence belongs to the current packet or not.
• The data repartition of that column is non-uniform, Histogram on that column should do the trick in order to get some execution plans switches.

I Observed the expected behavior(plan switches) with a feeded (persistent) normal (source) table plus statistics calculation performed (gather_table_stats) and histogram is present for the indexed column (as on some other)