Viewing Queries with bulkInsertRowCount

show_cached_plan_in_xml displays the cached execution plan with bulkInsertRowCount to indicate the bulk insert mode. The number enclosed in the bulkInsertRowCount tag is the row count inserted under bulk insert mode.

This example shows that 10240 rows were inserted by bulk insert:

<Insert>                                
<VA>1</VA>                                  
<est>                             
   <rowCnt>10240</rowCnt>                                          
   <lio>9.749939</lio>                                          
   <pio>9.749939</pio>                                          
   <rowSz>2</rowSz>                                  
</est>                                   
<arity>1</arity>                                                                         
<bulkInsertRowCount>10240</bulkInsertRowCount>                                         
   <TableScan>                                                          
      ……                                               
   </TableScan>                                   
<objName>t1</objName>                                  
<dataIOSizeInKB>16</dataIOSizeInKB>                                   
<updateMode> Direct</updateMode>                                   
</Insert>

show_cached_plan_in_xml is not available for select into because select into statements are not cached in Adaptive Server.