Interested to Buy Any Domain ? << Click Here >> for more details...
What is table partitioning and why is it required?
- 1 Answers
- 9 Views
- I also Faced
- E-Mail Answers
Answer / Preeti Saxena
Table partitioning is a technique used in Oracle to divide large tables into smaller, more manageable parts called partitions. Partitioning improves performance by reducing I/O operations, improving query response times, and simplifying maintenance tasks such as backups and index rebuilds. It is required when dealing with massive data sets that would otherwise lead to poor performance due to the increased resources needed for searching, sorting, and managing large amounts of data.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we identify the resources for which the sessions are waiting?
What do you mean by sga and how is it different from pga?
What are the conditions kept in mind while connecting the oracle rac with the network?
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
How can we monitor the space allocations in a database?
What is the load balancing advisory?
What are the file storage options provided by oracle database for oracle rac?
What is olr?
Mention where does the clusterware write when there is a network or storage issue?
How can a single instance environment be converted into rac environment and how will they be different?
What is a system tablespace and why do we need it?
Why do we need to rebuild indexes?
Oracle General 
