Re: Opinions on this schema please =)
Posted by:
Rick James
Date: February 22, 2009 02:13PM
(select ... from ... where general_category = xx) --
Add that column to your main table; index it; and do a JOIN instead of a subselect.
"selects can be tampered with later on anyways" -- I'm trying to warn you that tampering with the selects (and indexes) probably won't suffice; the problems are rooted in the underlying schema design.
According to the textbooks, your schema is nicely designed. But the textbooks don't worry about performance and scaling.
Subject
Written By
Posted
February 19, 2009 03:34PM
February 19, 2009 05:53PM
February 21, 2009 12:07AM
February 21, 2009 07:59AM
February 21, 2009 10:47AM
February 21, 2009 05:40PM
February 22, 2009 01:36PM
Re: Opinions on this schema please =)
February 22, 2009 02:13PM
February 22, 2009 08:41PM
February 23, 2009 09:13AM
February 23, 2009 09:36AM
February 23, 2009 04:27PM
February 26, 2009 05:15PM
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.