performace problem Help Needed
-
I have a performace problem which is killing me for last 5 hours
I have a report which fetches data from a view which internaly queries many tables
I have a parameter say empid which can be passed a single one or multiple ones.
This parameter empid is of type varchar and inside the proc we are extracting the ids and keeping in a table and joining teh same with teh view to get the result and its hanging when the data increased at teh client site.
but when i try where empid = 1 its coming in 0 seconds but i try the above method of keeping in a table variable and joining its hanging . can any one give me a solution for this ?
Thanks in advance
Jeswanth
--------------------------------
-
forgot to one more detail.
The execution plans are diffrent when i use where empid = 1 and
inner join. Is there any way i can use teh same execution plan for the join based solution ?
Jeswanth
--------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply