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
What do you mean by merge in oracle?
Can you create a synonym without having a table?
What are group functions in oracle?
how to clone 9i Database on to 10g Database.
Why is oracle used?
How to create an initialization parameter file?
Why does Oracle not permit the use of PCTUSED with indexes?
How to set up autotrace for a user account?
How to change system global area (sga) in oracle?
Why is oracle so popular?
What is different types of joins?
How to set a transaction to be read only in oracle?
What happens to the current transaction if the session is killed?
Will you be able to store pictures in the database?explain.
Explain the use of file option in exp command.