Re: Global Temporary Table

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 09 Sep 2004 05:19:21 +1000
Message-Id: <413f5b41$0$19871$afc38c87@news.optusnet.com.au>

Kenneth Koenraadt wrote:

> On 7 Sep 2004 15:50:46 -0700, hjr_at_dizwell.com (Howard J. Rogers)
> wrote:
> 

>>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

> 
> Blunder. GTT'S cannot be IOT's, which I somehow confused with "GTT's
> cannot be indexed".
> 
> - Kenneth Koenraadt

Fair enough. And, indeed, it is a significant bit of missed functionality on Oracle's part (a restriction, incidentally, which is still there in 10g. Not good).

Regards
HJR Received on Wed Sep 08 2004 - 14:19:21 CDT