Re: Adress table needed? Please give me some ideas! Thanks.
Posted by:
Bob Field
Date: March 20, 2006 07:56PM
Seller id should be primary, unique key.
Seller.addrId should be secondary key, not unique.
Merchandise id should be primary, unique key.
Merchandise.addrId should be secondary key, not unique.
Address id should be primary, unique key.
That should be all the keys you need to join the tables.
The additional indexes you propose probably won't help either because of lack of distinct values, or the overhead of maintaining them is more than the savings, unless they are used to join with still other tables.
Subject
Written By
Posted
Re: Adress table needed? Please give me some ideas! Thanks.
March 20, 2006 07:56PM
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.