Hello,
Current Situation:
I do Bulk Insert on a table that is later Clustered Indexed on a NON-Primary Column. After the indexing is done, end users can query for reports, etc.
New Plan:
I want to facilitate the end users so that they can query the ONLINE table rather than wait for the indexing and all that. For this reason, I need to create a Clustered Indexed beforehand and do the BULK INSERT time to time but this will cause a performance issue.
1. Is there any possible solution to improve the performance?
2. In SQL Server do we have anything like BIND VARIABLES in Oracle?
Wasif