--non clustered and non unique index Create Nonclustered Index NU_sort on CustomerDetails( sort desc, refCode asc )