Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> clustering tables question
When clustering two tables, for example:
Product_Groups (
id - primary key
group_name
)
Individual_Products (
product_group_id -foreign key to Product_Groups.id
product_description
)
Do you cluster on Product_Groups.id, ie) the primary key OR do you cluster on Individual_Products.product_group_id, ie) foreign key?
An example query might be:
SELECT group_name, product_description
FROM Product_Groups, Individual_Products
WHERE product_group_id = id;
Thanks in advance.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 10:26:11 CST