Collect stats on GTT

Database
Enthusiast

Collect stats on GTT

Hi,
GTT allows to have collect stats on single column but not combinations of column why is it so?

Also please specify where stats for indexes and column are stored for GTT like in permanent tables it is in DBC.TVFIELDS/INDEXES.....
2 REPLIES
Enthusiast

Re: Collect stats on GTT

Hi All,
Please reply..
Enthusiast

Re: Collect stats on GTT

Hi ,

Please note u can still collect stats on muticol of GTT but then these Multicol should be a part of PI only.

when u create GTT it DDL is stored in dict tables hence i think stats for the columns shouls be available in dict tables as u mentioned.
I need to check that but.

td_dba