Partitioning type

You can partition a table by hashing or by range. If you select Partition by hash, you must also specify a number of partitions to create. Your table will be divided into the specified number of equally sized partitions with each partition identified by a system-generated name and number.

If you select Partition by range, you control where each partition will begin and end. You can also specify the name and number to identify each partition, and how you want to handle null values. See Partition properties for more information on defining partitions created using range partitioning.

You can also choose not to partition the table by selecting Not partitioned.