I just want to ask that does custom query affect data size ?
I was experimenting on table. I simply pull one table as it is for extract and size was 5-6 MB and same table i tried to pull via custom query then i checked size and it was around 425 MB. Why there is so much difference is it just because of custom query or there might be any other reason?
Need more information.
What are you connecting to?
Do you have any joins?
Do you have any extract or datasource filters?
Size that you are referring to - is this a TDE file size?