Home » SQL & PL/SQL » SQL & PL/SQL » NONCLUSTERD Index Creation (ORACLE)
NONCLUSTERD Index Creation [message #448503] Tue, 23 March 2010 16:45 Go to next message
dvsrk
Messages: 5
Registered: March 2009
Junior Member
Hi,

i'm new to oracle environment.
Could some one let me know how can i specify NONCLUSTERD INDEX on Primary cloumn during table creation.

By default it will create clusterd index but i need non-clusterd index on it.

I'm using following stmt to create normal primary constarint during table creation,

CONSTRAINT PKFORM_PROPS PRIMARY KEY (FORM_PROPS_PK) USING INDEX TABLESPACE DB123_INDEX

Could some one let me know how can i change the above query, so that it should create NONCLUSTERED INDEX on Primary key column.

Thanks
Re: NONCLUSTERD Index Creation [message #448509 is a reply to message #448503] Tue, 23 March 2010 18:08 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
What makes you think it'll create a clustered index?
Re: NONCLUSTERD Index Creation [message #448536 is a reply to message #448503] Wed, 24 March 2010 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no CLUSTERED or NONCLUSTERED index in Oracle.

Regards
Michel
Re: NONCLUSTERD Index Creation [message #448924 is a reply to message #448509] Thu, 25 March 2010 17:24 Go to previous messageGo to next message
dvsrk
Messages: 5
Registered: March 2009
Junior Member
I'm a SQL guy, So i'm thinking in SQL point of view.
If i'm wrong what index does it create ?
Re: NONCLUSTERD Index Creation [message #448925 is a reply to message #448503] Thu, 25 March 2010 17:36 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
The normal index for oracle is a what Oracle calls a "balanced b-tree". With respect to your old database, oracle's standard btree index is non-clustered.

Here is a link from asktomhome that talks a little about it.

As tom notes, you might be interested in and IOT, index organized table as I suspect that when you say "clustered index" you really mean that rows in the table are "ordered" although as tom points out, this too is actually a mis-conception given todays disk storage methods.

Kevin
Re: NONCLUSTERD Index Creation [message #448957 is a reply to message #448924] Fri, 26 March 2010 00:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dvsrk wrote on Thu, 25 March 2010 23:24
I'm a SQL guy, So i'm thinking in SQL point of view.
If i'm wrong what index does it create ?

When you say SQL you think MS/SQL Server, here when you say SQL we mean Structured Query Language as this is an Oracle forum not a MS/SQL Server one.

Regards
Michel

Previous Topic: Case & Decode
Next Topic: Convert Object return type columns
Goto Forum:
  


Current Time: Sat Dec 03 12:28:52 CST 2016

Total time taken to generate the page: 0.04094 seconds