I am running a query with an UNLOAD statement to save the results into a CSV file,
UNLOAD SELECT ... FROM ... WHERE ... TO 'C:\\TEMP\\MyFile.csv' QUOTE '"';
I am getting status updates like
55% (1182880573 of estimated 2147483647 rows) complete after 01:10:00; estimated 00:57:04 remaining
and so on for 58%, 62%, etc. Does the update refer to the amount of time to write MyFile.csv, the amount of time to run the query, or both? That will help me figure out if the bottleneck is creating the file vs. running the query. The file size grew on disk over time to 539 GB, and the estimate undershot since it started giving values like,
769% (3635495259 of estimated 2147483647 rows) complete after 16:30:00
When I killed the query, it reported an execution time of 59706 seconds, so I think this retrieved a row, saved it to the file, retrieved the next row, and so on, but it would be nice to confirm.
I am using Sybase SQL Anywhere 12.