One of the database which we use is migrated from Greenplum to Oracle
So our team is doing some performance test by pulling same data from Oracle and Green Plum (1000 Records Table) to SAS where table coming from oracle DB is getting created by occupying 600 - 800 MB of size where as table coming from Green Plum is getting created by occupying 300MB of space under SAS work area.
And also date coloumn is getting created along with timestamp in table that was created from Oracle Database (tnsnames.ora) and same issue is not there on Green Plum (ODBC Connection).
Is there any setting that need to be done to avoid this or is it expected?