Re: Index clustered tables

On Thu, 2007-07-26 at 10:30 +1000, Sunny Bains wrote:
> Kalyan,
>
> Kalyankumar wrote:
> > 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.
>
> Oracle IOT => InnoDB clustered index. There is no equivalent of "CREATE
> CLUSTER" in InnoDB, which is what I presume you are referring to.

Yes, I'm referring to the 'create cluster' in Oracle
>
> http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/statements_5001.htm
>
> http://download.oracle.com/docs/cd/B12037_01/server.101/b10743/intro.htm#sthref69
>
> "
> Clusters
>
> Clusters are groups of one or more tables physically stored together because
> they share common columns and are often used together. Because related rows
> are physically stored together, disk access time improves.
> "
>
> Regards,
> -sunny
>
> Oracle/Innobase.

Is there any other storage engine in MySQL to implement this feature?

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