Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> IOT or Cluster or neither
I am evaluating a good table design to store data with the following
characteristics.
In order to increase the performance I have the following options.
A) IOT with primary key similar to "userid,id" B) Cluster the table on user_id (index) C) Cluster the table on user_id(hash)
Since the distribution of the data over "user_id" is not equal I'd like to get feedback from folks who have found themselves in similar situations and what solutions they have chosen and why.
Appreciate any input/comments
-- Adi Alurkar aalurkar_at_linkedin.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 18 2006 - 09:12:20 CDT
![]() |
![]() |