LutzM (8/9/2014)
You've mentioned to expect between 10 and 50 rows as the result set.However, the actual execution plan returned more than 280.000 rows.
Are those rows really returned?
Or is there usually a WHERE clause applied that you didn't use when runnning the query to get the actual execution plan?
[font="Comic Sans MS"]Nopes that was my mistake I assumed it to return 10 to 50 rows but when I reran the query it outputted around 2 lakh rows, and yes those rows are actual rows...nopes no where clause needed the query is as I've attached. As you reqd. the actual exec plan I've attached d same...so request you to kindly provide your valuable inputs
Regards,
Faisal
[/font]