Statistics Definitions

Naming:

Try to use name that is easy to identify

Keys:

To avoid ConstraintViolationException (duplicate key error), you need correct keys in the stat.def. As long as the combination of keys are unique, you should be OK

Field types

Try to use the correct field type according the information you retrieve. Note that VBU has a upper limit of how many fields you can use with the same type (Max 20).

Update strategy

When using UPDATE or ADD as a strategy, you should always use  a clean up routine so you don't fill up the database unnecessary.