In an effort to speed up a query I ran the “Index Tuning Wizard” and it recommended creating this view and index to improve the procedure by 98%.

CREATE VIEW [dbo].[Ims_view_Waiting_For_CkPoint3_to_Complete]

WITH SCHEMABINDING AS 

select  
orderfl.masterflid,  
ordprogfl.userid2o,  
ordprogfl.userid3o,  
orderfl.qtyord,
orderfl.orderflid,  
ordprogfl.ordprogflid
from [dbo].[orderfl],  [dbo].[ordprogfl]  
where ordprogfl.invflid = orderfl.invflid

go

CREATE UNIQUE CLUSTERED INDEX Sort1
on
Ims_view_Waiting_For_CkPoint3_to_Complete
(
masterflid	ASC,  
userid2o		ASC,  
userid3o		ASC,  
qtyord		ASC,
orderflid	ASC,  
ordprogflid	ASC
)

go

But by creating the above view & index I get this error every thing you try to add or update the tables involved. Can you help?

ODBC-ErrMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.tings: 'ARITHABORT'. '', l_type,;