What is the purpose of a cluster?
Answer / nishi
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are various constraints used in SQL?
What happens to the current transaction if the session is killed?
How to write a query with a left outer join in oracle?
Explain what are synonyms used for?
What are triggers?Where are they used?
Can a View based on another View ?
What is the parameter mode that can be passed to a procedure?
How to define an anonymous block?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What are the various types of snapshots ?
Difference between the “verify” and “feedback” command?
what is the syntax of SELECT command?