Post reply

Performance Tuning - Datatypes after CSV import

  • 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!

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply