0 - 3 of 3 tags for gtt

Can anyone help me on this question??... For GTT Tables while defining stats which one of the below Query works better?

collect stats on tablename column ColumnNM/Index


Hi Gurus,

I am looking for some guidelines on when to use each of the following form of temporary tables:

1) Derived Table

2) Volatile Table

3) Global Temporary Table

Any pointers will really help.


When using global temporary tables (GTT) as part of a larger script, can one user have multiple instances/aliases of the same GTT?

Ex: Table1 containing customer information with an order of $1,200 or more for the past 3 months.
Table2 containing customer information that have an account with VendorB.