Sql Covering Index Syntax

create nonclustered index indx_dmsmaster_companyname on dmsmaster(company_name)include(user_id,source_type,source)
create nonclustered index indx_dmslocation_locationdetails on dmslocation(master_id)include(area_id,category,city,dateofentry_loc,lastupdatedby,locality,mobile,pincode,presale_assign,state,telephone1,telephone2,telephone3,tse_name,typeofcard,validated,validated_remarks,validateddate,validator_code)

Comments