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 is BBED in Oracle?
How to get the Installed Oracle Version Information ?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How a tablespace is related to data files?
What is tns service name?
Explain the use of analyse option in exp command.
Give the various rollback segment states.
What is the maximum number of CHECK constraints that can be defined on a column ?
Can select statements be used on views in oracle?
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
Why is oracle used?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table