Hello Friends, Stuck in very strange situation. I have populated few tables for two set of parameters [equal number of records in each of them]. Now running the sproc with the different parameters is giving totally different results. For one set of parameters its taking just 8 seconds and for another set of parameters its taking around 45 seconds. The sproc contains just one select statement with joins between five tables. There is different execution plan for both set of params.
Statistics are updated in all the tables. Number of records for both the parameters is same in all five tables. Need your suggestions.