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 is integrity and what is constraint??Explain with example
How to save query output to a local file?
Explain the use of full option in exp command.
What is a cursor variable?
What is the difference between postgresql and oracle?
What is save point in oracle database?
Why oracle is used?
How to delete a column in an existing table?
Explain the use of compress option in exp command.
What are temporal data types in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to list all indexes in your schema?
Difference between varchar and varchar2 data types?
What to do if dba lost the system password?
please explain.. DB architecture ...