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 |
Can a formula column referred to columns in higher group ?
What is raw datatype?
select * from emp what happened internally when we write this query in the sql prompt?
What are the extensions used by oracle reports?
How to write a query with a right outer join in oracle?
What are the different type of Segments ?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
select statement does not retrieve any records. what exception is raised?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What is the difference between $oracle_base and $oracle_home?
What are the differences between blob and clob in oracle?
Explain the use of indexes option in imp command.