Re: Index clustered tables

From: Sunny Bains <Sunny.Bains(at)oracle.com>
Date: Wed Jul 25 2007 - 23:19:28 EDT

Kalyan,

Kalyankumar wrote:

> 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.
>> "
>>

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

Given that MySQL doesn't support the syntax, which will be required to pass the relevant information to the engine, I can't see how.

Regards,
-sunny

Oracle/Innobase.

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

Received on Wed Jul 25 23:21:05 2007