The suggestions given by Oracle are based on the size of the table. I remember that the recommendation for 10g is 2G, which means that the size of the table is greater than 2G, so it is best to create a partition.

Why create partitions? Mainly for the convenience of query, because if a table has millions of records every day, even if an index is established, it will not be very fast if you want to query it.

If you create partitions and query one partition each time, which is a fraction or even a few tenths of the table, then no matter how you calculate it, it will cost more than querying the entire table. Want less. And indexes can also be created on partitions.

The best principle for establishing partitions is query. This requires specific analysis of specific problems. Although some partition methods have a good number of entries, each query has to span 2-3 partitions. Such partitions are actually Personally I think it's a failure. It is best to limit the most commonly used queries to one partition, and the number of partitions cannot be too few (there are no specific requirements for this. Generally, Oracle recommends it based on size. I forgot how much it is. Again, it depends on you. requirements)

However, according to your question, for large data tables (those with large amounts of data), it is best to create partitions so that they can be easily checked and save resources and time.