what are the differences between L1 and L2 indexing types?

Beksalur,

Please complete your user profile with regards to the Baan software version, Database software and OS version. This will help other members when diagnosing your problem.

Please use the Search engine to look for known solutions before asking your question on the board.

Refer to - Level1 vs Level 2 (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=9723)

The difference between L1 and Level 2 is that in Level 2 the indexes are created on the columns e.g. orno and pono. In Level 1 an additional column has been added to the table with the name hash<index number>. This colum is not visible for the end user, but exists on database level. The content of this hash colum is more or less a concatenation of the fields orno and pono. I say more or less as the algorihm to do so is so complex that I advise not to try to update this column yourself. The real index now is created on the hash column.

This is the technique for Level 1 and 2 indexeing in a few lines.

Hope this helps,
Dick