Re: Global Temporary Table

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: 7 Sep 2004 15:50:46 -0700
Message-ID: <14a1f766.0409071450.5497cb46@posting.google.com>

Kenneth Koenraadt wrote in message news:<413dec60.1423453_at_news.inet.tele.dk>... [snip]

> FTS is the only option with global temp. tables, as indexing is not
> possible.
>
>
> - Kenneth Koenraadt

No doubt you'd care to explain this 9i feature then:

SQL> create global temporary table blah( 2 col1 char(5),
3 col2 number);

Table created.

SQL> create index gti on blah(col2);

Index created.

In short, of course GTTs can be indexed. And hence FTS's are not the only access path applicable to them.

Regards
HJR Received on Tue Sep 07 2004 - 17:50:46 CDT