What is Clustered Table in Oracle? Difference between Clustered Table and View?

A cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common.

Questions by Pradeep_Oracle

Showing Answers 1 - 2 of 2 Answers

Lokesh M

  • Feb 13th, 2012
 

A cluster is a group of tables which share the same data blocks.
Clusters are an optional method of storing table data.
Cluster share common columns and are often used together.
It is a powerful method of storing and organizing data in the dataset into groups or clusters of similar data. Oracle physically stores all rows for each table in the same data blocks.

A view can be considered as a virtual table, It is like a stored query which treats the output of the underlaying query as a table.

Read more here
http://www.geekinterview.com/talk/20450-what-cluster-table-oracle-diff-between.html#post61454

ravinder

  • May 4th, 2012
 

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions