| non cluster index [message #126518] |
Tue, 05 July 2005 06:16  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
|
can anybody explain me how to create a non cluster index in oracle and why it is used ?
|
|
|
|
| Re: non cluster index [message #126546 is a reply to message #126518] |
Tue, 05 July 2005 09:28  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
A non-clustered index is a standard index created on a table.
A clustered index is an index created on a cluster.
From the DB Admin Guide:
"After creating a cluster, you can create tables in the cluster. However, before any rows can be inserted into the clustered tables, a cluster index must be created. Using clusters does not affect the creation of additional indexes on the clustered tables; they can be created and dropped as usual."
Best regards.
Frank
|
|
|
|
| Re: non cluster index [message #126636 is a reply to message #126546] |
Wed, 06 July 2005 01:19 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Thanks Frank,
Actually somebody asked me this question and i replied the same that its a normal index created on the table but that fellow was not satisfied with my reply.
Thanks again
|
|
|
|
| Re: non cluster index [message #126737 is a reply to message #126518] |
Wed, 06 July 2005 07:35 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
I've never heard someone ask for a "non clustered" index before. Perhaps they are confused and thinking of a bitmap or something?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
