Hi all. Is there a way to improve performance on VALUE ENTRY Table. This is because processing is slow every time i reference it.

NB: asm using Nav DB


  1. On keys with SIFTS you aren’t using, disable the Maintain SIFT flag (a key property).

  2. On keys with SIFTS you are using, drill into the SIFT levels and only maintain the last few SIFT levels (or the ones you are using).

  3. Change the SQL Index on keys to be as selective as possible.

  4. Maintain statistics nightly on the table.

  5. Defragment the indicies.

  6. Rebuild the indicies.

  7. If necessary, move the table to a seperate hard disk - last resort.