Add Indexes to Databases

Modified on Wed, 16 Dec 2020 at 11:58 AM

Sometimes SalonTouch just seems to be slow to bring up customer's names or use the software. That's where indexes come into play.

  1. Navigate to C:\SalonTouch\Tools\
  2. Run the IndexUpdUtil.exe as administrator.
  3. Select the SQL Server Instance Name from the drop down at the top left.
    You may need to paste in the server name from SQL Server Management Studio.
  4. Use the SalonTouch Default Login for Local Servers.
    Use Windows Integrated for Hosted .net Servers.
    User Name and Password can be used for servers that the other UN & PWs do not work with.
  5. Click Connect
  6. Under the Database Names section on the right, the local 15 DB names will be populated or the hosted 2 database names will appear.

        7. Click Add Indexes.

        8. A new window will appear adding in Indexes. If the index exists, it will list it as Exists and skip it. If it does         not, it will add the index. It will not re-index any of the existing indexes.

        9. Once it lists Complete! click Exit.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article