Oracle SQL Question:
Explain What is the purpose of a cluster?
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.
it's a temporary and logical memory allocation where we can put several tables.
| Previous Question | Next Question |
| Select the Nth lowest value from a table? | Explain Difference between procedure and function.? |