Re: Vertical Partitioning
Posted by:
Rick James
Date: November 12, 2009 08:47PM
Yes, do a SELECT with a JOIN -- when you need fields from both tables.
Try to keep the things you search by in one table; the bulky things in the other. Then, some queries like this won't need both tables:
SELECT COUNT(*) FROM main
WHERE foo='bar'
AND date > DATE_SUB(NOW(), INTERVAL 7 DAY);
Subject
Views
Written By
Posted
3810
November 10, 2009 09:41PM
2592
November 11, 2009 11:57PM
2185
November 12, 2009 12:02AM
Re: Vertical Partitioning
2313
November 12, 2009 08:47PM
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.