Row order in cluster & non-cluster index?
This is a discussion on Row order in cluster & non-cluster index? within the Database Support forums, part of the Web Development category; Hi, Can anyone tell,If table has cluster index,how the records are store in table. Thanks, Prasath.K...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
08-08-2007, 12:35 AM
| |||
| |||
 Re: Row order in cluster & non-cluster index? Hi Buddy! A clustered index is a special type of index that reorders the way in which records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. Cheers....
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear!     |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What is a table called, if it does not have neither Cluster nor Non-cluster Index?.. | Archer | Database Support | 2 | 07-19-2007 12:19 AM |
| Cluster & Non cluster index | prasath | Database Support | 1 | 07-16-2007 05:29 AM |
| Oracle Cluster - Create and Alter Basic Syntax | Murali | Database Support | 2 | 07-11-2007 06:40 AM |
| cluster index in Oracle | vigneshgets | Database Support | 1 | 07-10-2007 07:22 AM |
| MySQL Cluster | Jeyaseelansarc | Database Support | 0 | 05-10-2007 01:30 AM |
All times are GMT -7. The time now is 04:57 AM.
