How to use Oracle to partition tables

This article mainly introduces "how to use Oracle partition table". In daily operation, I believe many people have doubts about how to use Oracle partition table. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "how to use Oracle partition table". Next, please follow the editor to study!

If the amount of data in a single table is too large, it will affect the read and write performance. We can use sublibraries and tables to solve the performance problem of a single table. Oracle's partitioned table physically divides a large table into several smaller tables, but logically it is still a complete table. In this way, only one partition table can be considered for each DML operation. Oracle recommends using partitioned tables when the size of a single table exceeds 2GB.

Today we are going to talk about the use of partition tables.

Partition Typ

Range partition

Range partitioning is the most commonly used partitioning method. It uses partitioning keys as the basis for partitioning. Partitioning keys can use time, id and other fields that are easy to compare.

1. Use id for partitioning

We create an operation record table with three fields, id,type and op_time. Here we use id to partition the table, which is called t_operate_log_1 (id).