MySQL Forums
Forum List  »  Partitioning

Re: Vertical partitioning
Posted by: Jonathan Stephens
Date: November 19, 2005 05:02AM

Hi Peter,

We're not currently doing any work on vertical partitioning that I'm aware of.

You can always split a table to achieve a similar performance gain, however.

My experience is that a table with a great number of columns very often indicates a need to further normalise the DB, but without seeing more, I can't say whether this might apply in your case. And if your schema is already normalised - well, I'm normally not a big fan of denormalisation, but this sounds like a case where it might be justified.

Jon Stephens
MySQL Documentation Team @ Oracle
Orlando, Florida, USA

MySQL Dev Zone
MySQL Server Documentation
Oracle

Options: ReplyQuote


Subject
Views
Written By
Posted
9012
November 07, 2005 05:44PM
Re: Vertical partitioning
3726
November 19, 2005 05:02AM
3729
November 30, 2005 03:30PM
3609
January 12, 2006 06:57AM
3475
January 12, 2006 08:55AM
3250
February 01, 2006 05:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.