Oracle SQL Question:

Explain What is the purpose of a cluster?

Tweet Share WhatsApp

Answer:

Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.

it's a temporary and logical memory allocation where we can put several tables.

Download SQL Oracle PDF Read All 16 SQL Oracle Questions
Previous QuestionNext Question
Select the Nth lowest value from a table?Explain Difference between procedure and function.?