What is partitioning? What are the types of partitioning?
- 1 Answers
- 1295 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is difference macros and prompts?
what is parallel query?
What are the vaious etl tools in the market?
How can you define a transformation? What are different types of transformations in Informatica?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Compare aggregates and data marts
How many ways we test the universe & Report?
What is DTS ?
Explain Association algorithm in Data mining?
What is Time Series algorithm in data mining?
Difference between ODS and Staging
What function should we use to display the value entered or selected by a user in response to a prompt?
Teradata 
