Performance Tuning - Datatypes after CSV import

• checkai

  Hall of Fame

  Points: 3041

  More actions

  December 19, 2011 at 8:46 am

  #391161

  I have a group that has imported millions of records based on CSV files. To no ones surprise, most fields have gone in as varchars and just terrible types. Now they are analyzing data and everything performs terribly. Is there any quick/easy way to help determine more appropriate types?

  Thanks!

• sturner

  SSC-Insane

  Points: 22411

  More actions

  December 19, 2011 at 11:16 am

  #1423231

  you should create your import table with the correct data type for each column.

  As an alternative, you can insert the data from your stage (import) table into a second table that does have the correct data types and indexes for your performance requirements.

  The probability of survival is inversely proportional to the angle of arrival.