0 Replies Latest reply: Jan 18, 2012 9:28 AM by user1779355 RSS

    hash partitioning v/s index clusters

    user1779355
      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