numeric vs float data type performance
yossibm
Vertica Customer ✭
Hi,
It looks like reading the same amount of data takes twice as much time using numeric(8,4) as opposed to float (using pyodbc, reading into pandas). Is it the expected behavior?
Thanks,
Yossi
0
Answers
found a workaround: cast to float on the select query.