What is the purpose of a cluster?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Calculate difference between 2 date / times in oracle sql?

568


What is Java Pool in Oracle?

602


How to define and use table alias names in oracle?

505


How to get a list of all user accounts in the database?

612


How to convert characters to times in oracle?

594






What is snapshot is too old? Give and example for better understand.

1098


Why do we need integrity constraints in a database?

584


What is a database table in oracle?

572


What are transaction isolation levels supported by oracle?

574


What is merge in oracle?

558


Will you be able to store pictures in the database?

636


What is oracle analytical function?

524


Explain the use of rows option in exp command.

585


What is a lookup table in oracle?

540


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1470