Re: Vertical partitioning
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
Subject
Views
Written By
Posted
9546
November 07, 2005 05:44PM
4026
November 19, 2005 05:02AM
4096
November 30, 2005 03:30PM
Re: Vertical partitioning
3912
January 12, 2006 06:57AM
3790
January 12, 2006 08:55AM
3444
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.