create proc ReBuildSearchIndexes as 
DECLARE @TableName VARCHAR(255)
DECLARE @sql NVARCHAR(500)
DECLARE @fillfactor INT
SET @fillfactor = 80
DECLARE TableCursor CURSOR FOR
SELECT OBJECT_SCHEMA_NAME([object_id])+'.['+name+']' AS TableName
FROM sys.tables
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'
EXEC (@sql)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
GO



IrIsSQLserverUser
irisProgramsSoftwareMangementPasswd


 CREATE UNIQUE INDEX compoundid_index 
ON compoundsdata (compoundid);

CREATE   INDEX orderdate_index 
ON orders (edate);


CREATE   INDEX orderdetail_itemcode_index 
ON orderdetail (compoundid);

CREATE   INDEX orderdetail_unitid_index 
ON orderdetail (unitid);

CREATE   INDEX purchases_itemcode_index 
ON purchases (itemcode);

CREATE   INDEX purchases_unitid_index 
ON purchases (unitid);

CREATE   INDEX taswyadetail_itemcode_index 
ON taswyadetail (itemcode);

CREATE   INDEX purchases_unitid_index 
ON taswyadetail (unitid);

CREATE   INDEX transferedetail_itemcode_index 
ON transferedetail (itemcode);

CREATE   INDEX transferedetail_unitid_index 
ON transferedetail (unitid);

CREATE   INDEX deliverytel1_unitid_index 
ON Delivery_customers (tel1);

CREATE   INDEX deliverytel2_unitid_index 
ON Delivery_customers (tel2);

CREATE   INDEX deliverytel3_unitid_index 
ON Delivery_customers (tel3);