Adaptive Server provides two mechanisms to help you observe runtime adjustments of query plans.
set process_limit_action allows you to abort batches or procedures when runtime adjustments take place or print warnings.
showplan prints an adjusted query plan when runtime adjustments occur, and showplan is effect.
