This discussion is archived
0 Replies Latest reply: Jan 18, 2012 7:28 AM by user1779355 RSS

hash partitioning v/s index clusters

user1779355 Newbie
Currently Being Moderated
We have moved an application to exadata x2-2. We are planning to convert our application tables from hash partitioning to using index clusters. The reason being that all the data for a particular subject ends up on same block or set of blocks physically. Contention is avoied on multithreaded system by moving data to diferent blocks using index clustered structure. Anybody has any experience using index clusters on exadata x2-2?
thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points