Troubleshoot

Troubleshoot common situations that may cause bulk insert optimizations to not be applied.

• Check the showplan output to confirm that:

  • The UPDATE INDEX operator is used.
  • The INSERT OPERATOR is using BULK INSERT. It is possible at runtime Adaptive Server decides to run the query without BULK INSERT even though it was used during compile time.
  • A sufficient number of worker threads is configured or available to perform the index updates in parallel.

• If bulk insert does not execute, set trace flag 9586 to diagnose the reason in the XML output.