index on global temp table

[crazy_jutt]

hi,

anyone knows if i can create index on global temp tables
if yes, will i use session schema for indexes also ?
if yes, can i create all kinds like unique, clustered, mdc etc indexes
in global temp table ?

please direct me to some web resource where i can find what all i can
do and i cannot do with global temp tables
regards,

[jefftyzzer]

You can create indexes on DGTTs, and you would use the SESSION schema.
You cannot create MDC "indexes" on DGTTs, as the syntax to create MDCs
is part of the CREATE TABLE statement. Lastly, you cannot CLUSTER
indexes on DGTTs. See the entries under "CREATE INDEX" and "DECLARE
GLOBAL TEMPORARY TABLE" the SQL Reference Volume 2 for more details.

--Jeff

crazy_jutt wrote:

hi,

anyone knows if i can create index on global temp tables
if yes, will i use session schema for indexes also ?
if yes, can i create all kinds like unique, clustered, mdc etc indexes
in global temp table ?

please direct me to some web resource where i can find what all i can
do and i cannot do with global temp tables
regards,