Re: Index clustered tables

On Wed, 2007-07-25 at 18:21 +0200, Guilhem Bichot wrote:
> Hello,
>
> On Wed, Jul 25, 2007 at 09:37:11PM +0530, Kalyankumar Ramaseshan wrote:
> > Is there a Index clustered tables in MySQL? Any of the storage engines
> > support this?
>
> I am not sure I understand the question well, but InnoDB has a
> clustered index: if the table has a primary key, the record is stored
> into the primary key's index. The details are here:
> http://dev.mysql.com/doc/refman/5.0/en/innodb-table-and-index.html
>

I know that InnoDB supports Index Oriented Tables (IOT's) but not Index clustered tables. In Index Clustered tables more than one table data is stored in a block. Such as if there is a DEPT table that has DEPTNO = 10001, all the rows corresponding to this key is stored in corresponding blocks that surrounds this key. In other words data is surrounded by the key value that is clustered. I think Oracle supports this kind of tables.

Regards
Kalyan

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com