On a table of about 100 columns and 1,000,000 rows, SQL Nav takes a long time from running the query to exporting the data to Excel. SQL Nav appears to be executing the query again during export, which may contribute to the performance lag. Is there a way to make it run faster?
SQL Nav 5.5 actually executes the query three times: 1. The actual run; 2. For spooling; 3. The export. There is nothing we can do about the export speed, but we can will try to minimize the actual run and spooling with the following settings.
1. Go to View | Preferences
2. In General | Session decrease the Read Buffer Size to 1
3. In Code Editor | SQL Script uncheck "Fetch All" and uncheck "Spool Output"
