When the query(s) have no single optimal plan. One example is when you have severe parameter sniffing, data skew or similar.
how do we come to know this ?
through exec plan ? how ? please explain or direct me to any link ?
-------Bhuvnesh----------I work only to learn Sql Server...though my company pays me for getting their stuff done;-)