Re: Global Temporary Table

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:14a1f766.0409071450.5497cb46_at_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
also works in 8.1.7.0.0

++ mcs Received on Tue Sep 07 2004 - 18:05:10 CDT