Database efficiency question
Posted by:
denis k
Date: January 04, 2011 10:46PM
Greetings everyone,
Having an issue with the creation of my schema.
I have 2 tables: Customer, Product
I need to keep track of which product each customer has. The website will be checking on each login which product the customer does not have and will display it to them.
I have 3 options:
a) create a seperate table to store all the product IDs and customer IDs
b) create a prod ID for each customer and do a select from product.prod_id where there is not one in customer.prod_id
b) create a cust_id in product to do the same as b)
Which of the 3 would be less strain on the database?
Thanks in advanced!
Subject
Written By
Posted
Database efficiency question
January 04, 2011 10:46PM
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.