CSV file to Sql server table

when doing a Bulk insert from CSV file to Sql Server table should the table have indexes? what is the effect with indexes or without indexes. Architect is saying that Bulk insert CSV loading Table with indexes cause issue with the heap. Can someone explain what happens where when doing this Bulk insert

more ▼

asked Apr 16 at 03:29 PM in Default

avatar image


(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 16 at 03:29 PM

Seen: 26 times

Last Updated: Apr 18 at 12:56 PM

Copyright 2018 Redgate Software. Privacy Policy