Re: Tables optimization for messages feature
Posted by:
Rick James
Date: February 13, 2011 06:27PM
1:Many -- 2 tables -- An id is unique in one table; occurs repeatedly in the other.
Many:Many -- 3 tables -- the middle table provides the mapping -- ids off to both tables occur repeatedly in the middle table.
If you would like to discuss further, please write out the CREATE TABLE statements and the INSERT and/or SELECT statements.
Subject
Written By
Posted
February 12, 2011 09:02AM
February 12, 2011 09:09AM
Re: Tables optimization for messages feature
February 13, 2011 06:27PM
February 14, 2011 03:15AM
February 15, 2011 11:26AM
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.