Hai gurus
I would like to know the major differences btw oracle level-1 and level-2 drivers

Thanks in advance

Major Differences?

Level 1 driver has 1 "hash column" added to the table per index on the table, and then oracle indexes are created on the hash columns.

Level 2 driver has indexes generated on the key fields.

(This means that 3rd party products can insert / update values in Level 2 Tables, but not Level 1 [ unless you can figure out the hash algorithm ] )

Level 1 driver is optimized for rule based queries

Level 2 driver is optimized for Cost based queries.

While Baan 4 was written to be optimized in Level 1, as time has gone by it is now more optimized for level 2.

Baan 5 is 100% optimized for level 2

Dave