What is a cluster and what is the real time use and business reasons to use Clustering

Questions by subbaraovangalli   answers by subbaraovangalli

Showing Answers 1 - 6 of 6 Answers

g_sidhu

  • Feb 5th, 2008
 

Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, their rows could be interleaved together in a single area, called a cluster. The cluster key is the column or columns by which the tables are usually joined in a query (for example, Title for the BOOKSHELF and

BOOKSHELF_AUTHOR tables).

KSPRADEEP

  • Oct 17th, 2012
 

Cluster are groups of one or more tables physically stores together to share common columns and are often used together

  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