What is Table Partitioning ?

Question

I want to know about Table Partitioning ? How do we do this?

Manish Kumar · Answer

Table parition is a very big topic. Refer below link to understand the concept of partitioning. In short partitioning is used for moving data from parent table to partition table if data count is very high for a table. We can define a range where a data for specific range can move to partition table. A range could be Date column in a table. https://www.cathrinewilhelmsen.net/2015/04/19/table-partitioning-in-sql-server-partition-switching/ https://www.sqlskills.com/blogs/kimberly/clarifying-left-and-right-in-the-defintion-of-a-partition-function-in-sql-server-2005/ http://sqlblogcasts.com/blogs/sarveshsingh/archive/2010/08/30/partitioning-part-2-managing-partition-using-split-merge-and-switch.aspx Thanks Manish

Mukil Vendhan · Answer

Partitioning enables tables and indexes or index-organized tables to be subdivided into smaller manageable pieces and these each small piece is called a partition. For more info: Partitioning in Oracle. What? Why? When? Who? Where? How?