MySQL – Vertical Partitioning Table of content The MySQL Partitioning is used to divide large tables into smaller partitions that are stored in different physical locations and are treated as separate tables. Even though the smaller partitions are managed individually, they are still part of the main table. There are two forms of partitioning in […]
Author Archives: user
MySQL – Cursors Table of content The MySQL Cursors A MySQL cursor is a pointer that is used to iterate through a table”s records. They are used within stored programs such as procedures and functions and have the following features − READ ONLY − Cursors only allow you to read data; you can”t make changes […]
MySQL – Horizontal Partitioning Table of content The MySQL Partitioning is a technique that can be used to divide a database table into smaller tables i.e. partitions. These smaller tables are stored in different physical locations and are treated as separate tables. Thus, the data in these smaller tables can be accessed and managed individually. […]