Posting Yak Master
Posted - 10/08/2013 : 21:21:31
| good evening, i nned your help
There is a table that contains about 750 millions of records and i would like to know which is the fastest method to export this table using these tools: bcp,a DTS tools,impot and exports wizard ? which one ?
this is the output used in sp:spaceused for the table:
HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303 740933108 200623976 KB 200602496 KB 1128 KB 20352 KB
i would like to export to five different flat text files using the command:
SELECT * FROM HECHOS_TRAFICO_LLAMADAS_DATOS_SMS_SCL_201303 WHERE FEC_PROC >= 20130301 AND FEC_PROC <= 20130305
obviusly i would use the index in the where clause right ?
2.On the other hand which is the fastest part to import a table using those flat text files as sources ?
Id appreciate your help in advanced