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
9038
November 07, 2005 05:44PM
3745
November 19, 2005 05:02AM
3751
November 30, 2005 03:30PM
Re: Vertical partitioning
3627
January 12, 2006 06:57AM
3487
January 12, 2006 08:55AM
3261
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.