If we have Employee Name as the Key to join two tables then it will join on the bases of Char fields ie Nikhil Garg.
But if we do autonumber(Employee Name) then it will give unique number to each record in Employee Name field. So instead of Nikhil Garg it can be numbers i.e. 1. So the performance may increase there is huge records in Employee Name fields, as we are joining on the bases of index(integer) instead of Char.
The AutoNumber() function is useful if you want to put a number on a specific field value, or on an attribute that is a combination of field values. The attributes will be numbered and their numbers re-used appropriately.
Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.
Examples:
autonumber( Region&Year&Month )
autonumber( Region&Year&Month, 'Ctr1' )
Autonumber is basically used to generate index which will help in joining the table and improve the processing time.
If we have Employee Name as the Key to join two tables then it will join on the bases of Char fields ie Nikhil Garg.
But if we do autonumber(Employee Name) then it will give unique number to each record in Employee Name field. So instead of Nikhil Garg it can be numbers i.e. 1. So the performance may increase there is huge records in Employee Name fields, as we are joining on the bases of index(integer) instead of Char.
