performace problem Help Needed

• Jeswanth Jaishanker

  SSCommitted

  Points: 1869

  More actions

  June 27, 2006 at 9:58 am

  #172809

   

  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

  --------------------------------

• Jeswanth Jaishanker

  SSCommitted

  Points: 1869

  More actions

  June 27, 2006 at 10:00 am

  #646114

  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

  --------------------------------