Re: N-to-N Model: Table Size vs Complexity
Posted by: dimitar nenchev
Date: May 18, 2009 04:54AM

So i far as i understand you mean that if there is 1 relation ship 1-2 there must be index userId, friendId and index friendId, userId
but if there are 2 relation ships 1-2, 2-1
There is need only for one index?

Options: ReplyQuote




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.