What is Data partitioning

0 votes
Hi!!

I am new to the database, can someone tell me what exactly data partitioning is and how does it benefit us?
Aug 22, 2018 in Database by CodingByHeart77
• 3,750 points
7,087 views

1 answer to this question.

0 votes

This is the process of partitioning tables, indexes into smaller pieces in order to manage and access the data at a finer level.

This reduces the cost of storing a large amount of data as well as enhances the performance and manageability.

Database partitioning also gives us the following advantages:

  1. Improves query performance and manageability.
  2. Simplifies common administration tasks.
  3. Acts as a key tool for building systems with extremely high availability requirements.
  4. Allows accessing a large part of a single partition.
answered Aug 22, 2018 by DataKing99
• 8,250 points

Related Questions In Database

0 votes
1 answer

What is Data Redundancy?

Duplication of data in the database is ...READ MORE

answered Aug 17, 2018 in Database by Sahiti
• 6,370 points
1,195 views
0 votes
1 answer

What is the best way to fetch data from table?

Hey Shraddha, I understand your doubts about fetching ...READ MORE

answered May 25, 2019 in Database by sampriti
• 1,120 points
1,955 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,390 points
1,223 views
0 votes
1 answer

What is Proactive/Retroactive/Simultaneous Update

Proactive Update: The updates that are applied ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,750 points
3,532 views
0 votes
1 answer

What is schema?

The description of a database is called ...READ MORE

answered Aug 17, 2018 in Database by CodingByHeart77
• 3,750 points
756 views
0 votes
3 answers

What is Phantom deadlock?

To understand phantom deadlock, you need an ...READ MORE

answered Feb 13, 2019 in Database by Ravi kumar
9,289 views
0 votes
1 answer

What is checkpoint in Database?

Checkpoint declares a point before which all ...READ MORE

answered Sep 4, 2018 in Database by Sahiti
• 6,370 points
1,809 views
0 votes
1 answer

What is the SQL query to get the third highest salary of an employee from employee_table

You can try out something like this: SELECT ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,370 points
12,392 views
0 votes
1 answer

What is Functional dependency?

A relation is said to be in ...READ MORE

answered Aug 10, 2018 in Database by DataKing99
• 8,250 points
786 views
0 votes
1 answer

What is Normalization of database?

Normalization is the process of organizing data ...READ MORE

answered Oct 8, 2018 in Database by DataKing99
• 8,250 points
1,201 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP