Clustering Help

[amerbaig]

I have three table

Table1
CountryId
CountryName

Table2
CityId
CityName
CountryId

Table3
Areaid
AreaName
CityId
CountryId

I want to create cluster on it. First I create Cluster on Country and make table1 is part of cluster, then I made table part of that cluster. Then I create new cluster on City and make Table3 part of second cluster. Please give me suggestions and confirm, If I am doing right.

Amer

 

[carp]

Since you are clustering all three tables and they have a common column (country_id), why not put them all in the same cluster?
Also, what type of cluster are you using - hash or index?

 

[amerbaig]

I am using index cluster. You are right, I should cluster oon Country. I also have structure similar to this

Table1
BUId
BUName

Table2
CityId
CityName
BUId

Table3
Zoneid
ZoneName
CityId