Database Partition

来源:互联网 发布:2017年文化产业数据 编辑:程序博客网 时间:2024/06/05 06:28
 

A partition is a division of a logical database or its constituting elements into distinct independent parts. The main goal is to reduce the amount of data read for particular SQL operations so that overall response time is reduced.

The partitioning can be done by either building separate smaller databases (each with its own tables, indices, and transaction logs), or by splitting selected elements, for example just one table.

原创粉丝点击