Answer Posted / hr@tgksolutions.com
Partitioning divides a large table into smaller, more manageable pieces.
Types of partitioning:
• Range Partitioning – Divides data based on a range of values.
• List Partitioning – Divides data based on a predefined list of values.
• Hash Partitioning – Distributes data based on a hash function.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is database or database management systems (dbms)?
Explain data independence?
What do you mean by index hunting?
What are the importance of partitioning in dbms?
What do you understand by query optimization?
Discuss some of the techniques that can be used to tune operational performance.
How to tell firebird to only accept conections from xyz host or network?
What is the difference between shrink database and shrink file?
How to create a database from my program?
What is the best database for big data?
Describe the difference between homogeneous and heterogeneous distributed database.
What is database management definition?
Explain degree of a relation?
What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....
Why is foreign key used?