Add creation view sql affinitic refs #5828