time out expired error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

time out expired error

hi I have table with 10 columns,that table having 10 lack record,
from appication one query running that is picking up the data like this SELECT <all fields> FROM TABLE1 where NAME<varchar(20)> AND TEXTID<varchar(122)> some time this query giving error like "time out expired error" any how it is very slow how can solve this problem
regards SreenivasaRao
do you have index on NAME AND TEXTID fields.
check the exucution plan whether it takes index seek or table scan. —————————————-

No index on table,is it recomenedable having index’s on this table SreenivasaRao
No index, no speed. First lesson in database design …
oops. index are must for performances.
go through some articles on this site —————————————-