Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> clustering tables question

clustering tables question

From: <kal121_at_yahoo.com>
Date: Wed, 16 Dec 1998 16:26:11 GMT
Message-ID: <758muu$lfv$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US