Viewing Queries with UpdateIndex

show_cached_plan_in_xml displays the cached execution plan using UpdateIndex to indicate that multiple indexes are applied in parallel.

This example shows the UpdateIndex operator output that updates multiple indexes in parallel:

<EmitXchg>
<Details> 
<VA>2</VA>
   <Vtuple Label="OutputVtuple">
   <Collection Label="Columns(#1)"> 
   <Column>
   (0x0x1497d6f00) type:INT1len:1 offset:0 valuebuf:0x(nil) 
status:(0x00000000)
(constant:0x0x14a10e760 type:INT1 len:1 maxlen:1 ) 
   </Column>
   </Collection> 
   </Vtuple>
</Details> 
   <UpdateIndex Label="UpdateIndex:"> 
   <Details> 
      <VA>1</VA>                          
   </Details>                          
   </UpdateIndex>
</EmitXchg>

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