SQl performance -Indexing

Asked Jan 12 '15 at 10:00

Active Jan 16 '15 at 07:55

Viewed 39 times

Here I am having a table called Tuser with greater than 100K records as I need to get those records directly with a conditiion

here is my query

SELECT TU.USERID,TU.ORGUNITID,TU.LOGINNAME,TU.LOGINPASSWORD,TU.FIRSTNAME,TU.LASTNAME,      
  TU.HINTQUESTION,TU.HINTANSWER,TU.CONTACTID,TU.STATUSTYPE FROM TUSER(NOLOCK) TU       
  INNER JOIN TUSERORGUNIT(NOLOCK) TUO ON TUO.USERID = TU.USERID      
  WHERE TU.ORGUNITID = @ORGUNITID

it is taking 4 to 5 sec when there are lessa than 3k records

now its taking on an average 35sec to execute.

This is my Execution plan

enter image description here

Do I need to create any index? and why? can u explain?

edited Jan 16 '15 at 07:55

asked Jan 12 '15 at 10:00

Surendra

Which DBMS are you using? SQL Server? Oracle? MySQL? – dario Jan 12 '15 at 10:08
Which DB? have you checked explain plan? It will show which part of query is taking time. – Nachiket Kate Jan 12 '15 at 10:23
SQl Server 2008 R2.. i checked execution plan .. – Surendra Jan 12 '15 at 10:54
can u add create scripts on those two tables? – Giorgi Nakeuri Jan 16 '15 at 07:59

SQl performance -Indexing

0 Answers0