Re: Index cluster with one table

From: Jonathan Lewis <>
Date: Fri, 25 May 2012 13:44:24 +0100
Message-ID: <>

"vsevolod afanassiev" <> wrote in message
|A vendor provided scripts for table creation in a new database.
| Some tables get created in index clusters, however each cluster
| contains only one table.
| Does it make sense? I thought that idea behind clusters was to combine
| two or more tables to make joins faster.

Yes, it can make sense.

You might want to cluster together rows from the same table even though they appear at very different times. Clustering for joins was just one reason for clustering. Note that Oracle uses many single table (hash) clusters in its TPC-C records.

The same time of thinking applies to Index Organized Tables - data arrives in one pattern, but is stored in another pattern for faster (group) retrieval.


Jonathan Lewis
Oracle Core (Apress 2011)
Received on Fri May 25 2012 - 07:44:24 CDT

Original text of this message