New answers tagged

0 votes

Tsql help - doing a large update from CSV file to a table in ssms

there's an easier way to import csv files with a very neat formatting, you'll do it on 2 steps: 1- run the following query on the file to check number of columns and their names: select top 1 x.* ...
user avatar
  • 136
2 votes
Accepted

UPDATE FROM with a large table is slow and uses Seq Scans

... we need to set the 'current' flag true for 98% of rows So NOT current will be the rare case. Seems like you have been trying to do things back to front so far. Your current indexes are actively ...
user avatar
1 vote

UPDATE FROM with a large table is slow and uses Seq Scans

I don't think you should try to avoid every seq scan. But you do not want a seq scan which will be executed a large number of times (like in a un-hashed subplan, or in the 2nd child of a nested loop)....
user avatar
  • 32.1k

Top 50 recent answers are included