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
09342196319

---

do you have index on NAME AND TEXTID fields.
check the exucution plan whether it takes index seek or table scan. —————————————-
http://dineshasanka.blogspot.com/

---

No index on table,is it recomenedable having index’s on this table SreenivasaRao
09342196319

---

No index, no speed. First lesson in database design …

---

oops. index are must for performances.
go through some articles on this site —————————————-
http://dineshasanka.blogspot.com/

---

]]>