All Forums Tools
MARAN_CHENNAI 24 posts Joined 08/08
01 Aug 2008
Collect Statistics

Hi Folks,Can any one tell me , can we collect the statistics against GTT table ???

Fred 1096 posts Joined 08/04
01 Aug 2008

Include the keyword TEMPORARY in front of the table name to collect statistics on a materialized instance of a GTT.If you "collect stats" on the base GTT definition (without TEMPORARY), it effectively creates a default list of indexes and columns that can be used for a "re-collect" request on each materialized instance.

You must sign in to leave a comment.