This option is not required if the database is Microsoft SQL Server.
When a Sybase SQL Anywhere database becomes too large, the performance slows due to the Keyword Type matching that is performed on the database level. The Use Other SQL Method option (Export/Publishing Options) is used to optimize the performance of Sybase SQL Anywhere database functionality when either exporting or publishing.
If the time to produce the exported or published data dramatically increases, determine which Keyword Types may be responsible for the decrease in performance and enable the Use Other SQL Method setting for those Keyword Types. To determine which Keyword Types are decreasing performance, run a verbose report.
Performance may also be improved by configuring the Export Format configuration with the Use Alternative SQL Anywhere Select Method.