Re: Index clustered tables

On Thu, 2007-07-26 at 07:42 -0400, Chad MILLER wrote:
> On 25 Jul 2007, at 23:19, Sunny Bains wrote:
>
> > 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.
>
> ...and we're unlikely to add syntax for something that nothing
> supports? There's no catch-22 here. I'm sure we'd provide a method
> to get the information down to the storage engine. We need a
> pioneering storage engine to do it. If you're willing to implement
> it, I'm pretty sure we'll find a way.

Sure will give it a try. But not sure how long it'd actually take for me to post the basic working code as I have to start (indeed to pioneer) it and keep going with it.

Honestly, my intention for asking this question in this list is to get pointers to the source code for Index Clustered Tables if it had already existed in MySQL so that I can read it & understand the DS well, as I was very eager to know the internals (about storage of clustered key,data in disk etc) & working of ICT in other database system. I really didn't expect this to get to this stage now here. But well it's going to be little difficult, but interesting as well I think. Let me see if I can do this.

>
> - chad
>
> --
> Chad Miller, Software Developer chad@mysql.com
> MySQL Inc., www.mysql.com
> Orlando, Florida, USA 13-20z, UTC-0400
> Office: +1 408 213 6740 sip:6740@sip.mysql.com
>
>

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