René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
create cluster [Oracle SQL] | ||
Index clustercreate cluster cluster-name ( column-1 datatype, column-2 datatype, ... column-n datatype ... ) [ physical-attributes-clause ] [ size size-clause ] [ tablespace ts-name ] [ index ] [ parallel ] [ { rowdependencies | norowdependencies } ] [ { cache | nocache } ] ;
The optional index clause makes the statement create an index cluster.
Hash clustercreate cluster cluster-name ( column-1 datatype [ sort ], column-2 datatype [ sort ], ... column-n datatype [ sort ] ... ) [ physical-attributes-clause ] [ size size-clause ] [ tablespace ts-name ] [ single table ] hashkeys [hash is expression ] [ parallel ] [ { rowdependencies | norowdependencies } ] [ { cache | nocache } ] ;
The hashkeys clause makes the statment create a hash cluster. With hashkeys, index cannot be specified.
|