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 are stored-procedures? And what are the advantages of using them.
Is it possible to declare or create a cursor for update of table? If yes tell me how?
How to debug stored procedures?
What is the definition of database management system?
What is the difference between a database and a spreadsheet?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
What is a database in a website?
What are procedures in dbms?
How can I access my database remotely?
How to start and stop database control?
What are the two types of indexes and explain them in detail?
Explain the Surrogate Key in DBMS.
How is foreign key commands related to primary key?
Is access a database program?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?