1 Reply Latest reply on Apr 11, 2014 6:21 AM by philmodjunk

    Indexing and performance - general

    jmmx

      Title

      Indexing and performance - general

      Post

           Is there a good reference on how indexing affects system performance?

           Thanks!

        • 1. Re: Indexing and performance - general
          philmodjunk

               In most aspects, indexed fields mean better performance. In some aspects, it can mean much slower performance.

               Searches and sorts are many times faster when they are done only on fields that are indexed.

               But actions that require the addition, deletion or change of large numbers of records in a table will be much slower if the fields in that table are indexed. So importing large blocks of records, deleting large blocks, running a Replace Field Contents or looping update script to modify a large block of records will be much slower.