An Oracle "cluster" is used to prejoin two (or more) tables on a specific column(s), called the cluster key. Almost every time I have determined that a cluster is beneficial, I have just denormalized the tables and created one table out of the two tables. There are exceptions to this rule. If you do need a cluster, you have to create the cluster first and then create the tables as part of the cluster.
Without knowing more about your exact situation, I would guess that what you really want is just a normal index on the table to speed up query processing.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.