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 the syntax of ALTER command?
Explain the use of Merge statement in oracle 11g
how to find count rows in table without count function?
What is oracle database client?
how to create a new database in oracle?
How to change program global area (pga) in oracle?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
How to enter a new row into a table interactively?
Explain coalesce function?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Define oracle database
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10