Skip to main content

EXECSYNC

Short Description

Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator. Examples of such areas are bitmaps, large binary objects (LOBs), and the spool iterator. LOBs may frequently use this wait state.

Detailed Description​

During parallel query operations, it is necessary for temporary objects to be set up. You will see the EXECSYNC wait whilst these objects are being prepared for use.

How to reduce this wait​

Not available yet. Contributions welcome.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.