Oracle Database Discussions

Hi there,

here is my situation (Oracle 10gR2): As an example I take the Oracle OE-Schema

select *
from customers a, orders b, order_items c
where a.customer_id = b.customer_id
and b.order_id = c.order_id;

Hopefully this SQL makes clear, what I intend to state: a SQL, joining three tables, going from PK to FK. So, say, the case corresponds the case for cluster tables: DML, SELECTs mostly occur on all three tables in a correlated way.

So since I query almost always, all three tables, joined together, I would try to cluster them. But how, since I have a different join condition for each pair?

Should I create two clusters, of customers and orders on customer_id and of orders and order_items on order_id? Can a table be in two clusters?

Thanks for any suggestions!