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".
Received on Wed Sep 08 2004 - 11:31:44 CDT
