hi we are exetiong Stored proceduer on Sql server 2008.stored proceduere exetting throuth temp tables and table varibles.lot of time consuming for execution. if sp having temp tables and table varibles then how to know the displsy estimated Execution plan for indexes.i have selected sp and right click selected by estimated executioon plan it is showing error.