Hi, I have a query and runs against a large table having half a million records. Can ne body tell me how to troubleshoot index searches/sec which is the highest when checked with performance counters ? i am putting down my query if ne body could suggest.. way to write it or index the columns. Query: SELECT C.USERNAME, RIGHT(C.PLAN_TYPE, 2) AS PTYPE, C.TOTAL_SESSION, C.IPADDRESS AS IPADDRESS FROM DBO.USERS_AUTHENTICATION C WHERE C.BACKUPACCTSTATUS = CASE C.PLAN_TYPE WHEN 6 THEN 1 ELSE 0 END AND C.USERNAME ='xxx' Thanks in advance. RoyalSher. ********* The world is the great gymnasium where we come to make ourselves strong.