Hi all,
I am using a SP to the Explained task as below :
Using BCP to transfer Data into temp table.
Reading Data from temp table.
Validating the Data. Like check of Duplicacy. Error Handling and all.
This takes Lots of time to process the Loading.
Can any one suggests how to optimize the performance ?
Can i use indexing inside SP or better use Index Before Execution?
Thanks