Hi experts,
I would like to know about the table indexes that how many indexes we can maintain in a table and how many fields can be there in a single index.

Hi experts,
I would like to know about the table indexes that how many indexes we can maintain in a table and how many fields can be there in a single index.

Hello,

http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_overview

Regards

Hi,

> maximum number of indices per table is 20.
> maximum number of fields is 16 (each individual field in a combined field counts as 1). This limit is not enforced by the porting set, but should be obeyed when developing standard software. The limit is raised by Microsoft SQL Server.

Hi,

take a look at the known limits (http://www.baanboard.com/programmers_manual_baanerp_help_misc_known_limits).

Indexes

maximum index length is 120 bytes
maximum number of fields is 32 (no combined fields)
maximum number of index parts is 8