MySQL Forums
Forum List  »  Partitioning

Re: Vertical partitioning
Posted by: Ziemowit Jankowski
Date: January 12, 2006 06:57AM

Just wondering...

How can a view improve your performance? Unless MYSQL has taken special measures, you will have to fetch the whole wide record in order to access a few columns, regardless whether you access via table name or via view name.

Splitting the table into two or more with same PK and different columns is probably the better way to do the trick...

Ziemowit Jankowski, DB Architect, 54u

Options: ReplyQuote


Subject
Views
Written By
Posted
9057
November 07, 2005 05:44PM
3758
November 19, 2005 05:02AM
3768
November 30, 2005 03:30PM
Re: Vertical partitioning
3638
January 12, 2006 06:57AM
3498
January 12, 2006 08:55AM
3269
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.