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
How to assign data of the deleted row to variables?
How to define a data field as not null?
What are data pump export and import modes?
Is a rollback possible to any savepoint?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to use subqueries in the from clause in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
State some uses of redo log files?
How to define a variable to match a table column data type?
How to convert csv to table in oracle?
How do I manually create a database in oracle?
How to change user password in oracle?
How to create a table in a specific tablespace?
Explain the use of grant option in exp command.
How to retrieve data from an cursor to a record?