• patientnumber looks unique keep this a primary key and create non clustered index as per requirement.

    covering index column will work faster than columns not in any columns.

    Regards
    Durai Nagarajan