Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index Help !
I have transitioned from Informix to Oracle and am having some
difficulties in performing some fundamental db tasks in my new
environment. I need to create a clustered index on a table. Maybe its
just lack of knowledge on my part. But, when I mention this to anyone
they seems to confuse a clustered index with an Index on a cluster. Is
it possible to create a clustered index ( an index which reorder the
physical table in the order that the index designates.) on a table
using version 8 ? If so, what is the syntax ?
Thanks.
--
Jorge Torralba
SMG Applications Group
Intel
5200 N.E Elam Young parkway
JF1-18
Hillsboro OR, 97124
(503) 712-1731
Jorge.Torralba_at_Intel.com