Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2010 @ 14:03:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

There are restrictions on stats on GT tables. Here are some rules from some info I have:

Rules for using InsertStats on Global Temporary tables:

You can collect most statistics on a global temporary table with the following exceptions:

You cannot collect statistics on multiple columns.

You cannot collect statistics on a named index by index name for a materialized global temporary table.

You cannot collect PARTITION statistics.

Table must be materialized in order to run collect statistics on it (at table level.

So, following the above rules, apply stats on the 'un-materialized' table. Then, after the table is materialized, then you can execute the COLLECT STATS ON ; This information was good as of 2.6.2 - not sure if any of these were lifted on TD12 or greater - but, you could chekc the manuals!

The manuals are pretty clear on this;-)

JK

	<Prev	Next>		<<First	<Prev	Next>	Last>>