indexes

CREATE INDEX [ix_aiawfenquiry_distr_type] ON [dbo].[awfenquiry] ( [distr_type],[element_type],[oid] ) INCLUDE (wf_user_id,error_no,version_no,p_description,s_description,proc_node_id,step_node_id)
CREATE INDEX [ix_atstsehourdet_client] ON [dbo].[atstsehourdet] ( [client],[tsehourdet_id],[tsegldetail_id],[wf_state],[used_hrs] )
CREATE INDEX [ix_atstsegldetail_client ] ON [dbo].[atstsegldetail] ( [client],[tsegldetail_id],[tseheader_id],[chargecode_id])
CREATE INDEX [ix_atstseheader_tseheader_id] ON [dbo].[atstseheader] ( [tseheader_id]) INCLUDE (reg_period,resource_id,last_update)
CREATE INDEX [ix_atschargecode_client] ON [dbo].[atschargecode] ( [client],[project],[chargecode_id])
CREATE INDEX [ix_atsproject_client] ON [dbo].[atsproject] ( [client],[project])
CREATE INDEX [ix_atstsehourdetmap_tsehourdet_id] ON [dbo].[atstsehourdetmap] ( [tsehourdet_id],[oid])