468,549 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,549 developers. It's quick & easy.

index on global temp table

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,

Nov 16 '06 #1
1 3837
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,
Nov 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Sean C. | last post: by
reply views Thread by gwaddell | last post: by
2 posts views Thread by chettiar | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.