Adding an Index to a GP table

  • Adding an Index to a GP table

    Posted by DSC Communities on December 7, 2016 at 1:06 pm
    • Douglas Hart

      Member

      December 7, 2016 at 1:06 PM

      I am processing a huge File —- PM30200 — AP History

      I am thinking if I add a date key – I can retrieve records quicker —- my SQL execution plan is showing that

      it is doing a complete table scan and I am hoping a date key and a where date = ‘xx-xx-xxxx’ will speed it up significantly

      Thanks

      ——————————
      Douglas Hart
      Dynamics Administrator
      Forex Capital Markets
      New York City NY
      ——————————

    • Bruce Strom

      Member

      December 7, 2016 at 2:47 PM

      To the best of my knowledge you can add and index in SQL directly, Dr. Google agrees, search “adding index to great plains dynamics table”.

      Dr. Google suggests:

      http://www.accoladepublications.com/GP-System-Tips/increasing-performance.html

      Use an index name that varies from the Great Plains naming convention.

      ——————————
      Bruce Strom
      Programmer
      Associated Grocers of Florida
      sunrise FL
      ————————————————————————-

    • Curtis Cruz

      Member

      December 7, 2016 at 3:12 PM

      Just remember, when creating indices on GP tables, after upgrading, your indices will disappear.  This is due to GP copying the data from it’s original tables during an upgrade, it then creates the new table to include any changed fields or indices, and copies the data back to the newly created table thus removing your index.

      So, be sure to script your indices to be used after an upgrade or service pack install if the upgrade hasn’t already added the index you are looking for.

        

      ——————————
      Curtis Cruz
      Database Administrator
      Apex Healthcare Partners LLC
      Montebello NY
      ————————————————————————-

    DSC Communities replied 7 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Adding an Index to a GP table’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!