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
9707
November 07, 2005 05:44PM
4095
November 19, 2005 05:02AM
4195
November 30, 2005 03:30PM
Re: Vertical partitioning
3987
January 12, 2006 06:57AM
3876
January 12, 2006 08:55AM
3513
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.