Check NONCLUSTERED INDEX created or Not on any iVend tables

Check NONCLUSTERED INDEX created or Not on any iVend tables

Environment : 

iVend Version 6.6 with SAPB1 9.2

Problem Statement: 

How to check that NONCLUSTERED INDEX created on any iVend tables

Symptoms :

How to check that NONCLUSTERED INDEX created on any iVend tables

Resolution/Work Around : 

Run the Below query and check the output.
.............................................................................
select o.name as Table_Name,i.name as Index_Name,I.type_desc
from sys.indexes as I with (nolock) inner join sys.objects as O with (nolock) on I.object_id=O.object_id 
where i.type_desc='NONCLUSTERED' order by Table_Name desc
 ..........................................................................

    • Related Articles

    • iVend 6.6 Performance Issues-Required SQL Index

      This KM is for Internal Purpose Only for CitiXsys Environment: iVend 6.6 Problem Statement: We have noticed that customers are facing performance issues with iVend 6.6. Symptoms: Environment Specific Resolution/Work Around: Technical Team has checked ...

    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

    • Database health check & Optimization steps

      Steps and walkthrough to do a health check and optimization of iVend database. The entire process broadly consists of 8 steps: Step 1: Take Backup of DB. Open SQL Server Management Studio Express and connect to the SQL server. Expand Databases. ...

    • POINTS TO CHECK POS PERFORMANCE

      Checkpoints There are below check points on POS Performance : 1.Collect the data from Customer in a word document. ( Refer the attached file) 2.CHECK SYSTEM RAM SIZE : Check POS System RAM This should be as Per Ivend Hardware Guide (Take Screenshot ...

    • Find the details of the UDT(user defined Tables) in ivend after integration from SAP.

      Product Version: iVend 6.5 update 6 with SAP B1 Version 9.3 Problem Statement: To find the details of the UDT(user defined Tables) in iVend once integrated from SAP. Proposed Solution: To find the details of UDT in iVend which are integrated in iVend ...