grasp06110 wrote:
> Hi Everybody,
>
> Does anyone have an suggestions on how to optimize a join on data from
> both sides of a many to many relationship? It sees that I can get
> very quick queries for anything on either side of the many to many but
> when a try to join accross the many to many relationship there is no
> way to do it quickly.
Many to many relationships don't belong in a relational design. You
need to fix the architecture to use an intersecting entity between them.
The alternative is to fight this forever.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 31 2007 - 19:39:55 CDT
