abhas (12/10/2013)
Thanks Phil,But there is no Primary key in the target table , so can go with non-clustered index or clustered index?
Thanks
Abhas.
Why does the absence of a PK have any bearing on dropping and creating an index? Is there something you are not telling us?