0 - 3 of 3 tags for gtt

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

collect stats on tablename column ColumnNM/Index

OR
2.

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.