Any activity that may impact a statement's execution plan is a candidate for using SPA to investigate the possible consequences - both good and bad. Steve Callan discusses the workflow and provides a working example.

This story continues at
http://www.dbasupport.com/oracle/ora...Analyzer.shtml