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?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Hi can you explain about cluster index in Oracle? |
|
#2
| |||
| |||
| 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
-R.Gopi |
![]() |
| Thread Tools | |
| Display Modes | |
| |
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 |
Our Partners |