Arrays are database objects from which multiple users can generate unique integers. The array generator automatically generates sequential numbers that can help generate unique primary keys and coordinate keys across multiple rows or tables.
Without arrays, serial values can only be generated programmatically. A new primary key value can be obtained by selecting and incrementing the last generated value. This method requires deadlocking during the transaction and causes multiple users to wait for the next value of the primary key. This wait is known as serialization. Arrays eliminate serialization and increase the concurrency of an application.
After selecting a Database Schema , you can specify a prefix and then you need to define the following values: