IT Community - Software Programming, Web Development and Technical Support

cluster index in Oracle

This is a discussion on cluster index in Oracle within the Database Support forums, part of the Web Development category; Hi can you explain about cluster index in Oracle?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 05-17-2007, 05:25 AM
vigneshgets vigneshgets is offline
D-Web Genius
 
Join Date: Mar 2007
Posts: 904
vigneshgets is on a distinguished road
Wink cluster index in Oracle

Hi can you explain about cluster index in Oracle?
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 07-10-2007, 06:22 AM
Gopisoft Gopisoft is offline
D-Web Sr.Programmer
 
Join Date: Feb 2007
Posts: 119
Gopisoft is on a distinguished road
Default Re: cluster index in Oracle

Hi,

A cluster is an method to store data for more than one table in the same segments. A cluster can be compare to a condition, what we have a join condition of two tables (primary key of a one is the foreign key in a other table).

Two types of cluster index
  • Cluster Index
  • Non-Cluster Index

Cluster Index
  • A table contain only one cluster index
  • Cluster index have physical sorted index.

Non-Cluster Index
  • A table contain non-cluster index upto 249.
  • Non-cluster index is more faster than cluster index.
  • Non-Cluster index have to create the pointer of the data

-R.Gopi
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyper-V R2 - Failover Cluster Cluster Name resource fails to come online arjkhanna Operating Systems 4 04-07-2009 02:01 AM
Row order in cluster & non-cluster index? prasath Database Support 1 08-07-2007 11:35 PM
What is a table called, if it does not have neither Cluster nor Non-cluster Index?.. Archer Database Support 2 07-18-2007 11:19 PM
Cluster & Non cluster index prasath Database Support 1 07-16-2007 04:29 AM
Oracle Cluster - Create and Alter Basic Syntax Murali Database Support 2 07-11-2007 05:40 AM


All times are GMT -7. The time now is 02:34 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0