Harvest

 View Only

TECH TIP: Question on Indexes for V13

  • 1.  TECH TIP: Question on Indexes for V13

    Posted Jun 21, 2017 10:21 AM

    Question: I would like to know if these table re-indexing files are also applied for version 13 and if they have any other specific documents to perform a database tuneup.
    What we want to achieve is an improvement in database performance.

    Estimated time of this process too.

     

    Answer: Dropping and rebuilding indexes should apply to ALL databases where client users add and

    delete data on the database regardless of the Harvest version. Indexes will deteriorate over time therefore the DBA should schedule this as part of the normal database maintenance period.

    It is unknown how long this process takes because it really depends on the volume of the database.