What is partitioning? What are the types of partitioning?
- 1 Answers
- 1290 Views
- I also Faced
- E-Mail Answers
Answer Posted / Sauravh Kumar
Partitioning is the process of dividing a large database table into smaller, more manageable pieces called partitions. This improves performance by reducing the amount of data that needs to be processed during queries and operations such as backups or index rebuilds. There are several types of partitioning:
1. Range partitioning: Partitioning based on a range of values (e.g., date ranges, ID sequences)
2. List partitioning: Partitioning based on specific values or lists (e.g., regions, departments)
3. Hash partitioning: Partitioning based on a hash function applied to the partition key
4. Key partitioning: Partitioning based on the value of the primary key
5. Composite partitioning: Combining multiple partitioning methods to create more complex partitions
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
Explain how to generate iqd file from framework manager?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
