Query Help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Query Help

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2011-12-08 : 22:46:17

I have table with very huge data with no primary_key or index defined
When doing the update it is taking 45 mins..

Please suggest.

Thanks for your help in advance..


Student
--------

Stu_ID  varchar(1000)
stu_dt varchar(1000)
stud_Loc varchar(100)
Stud_Jstatus varchar(1000)
Stud_lg varchar(1000)
stud_course_time varchar(1000)

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-12-08 : 23:42:52

how about just create the index ?

KH
[spoiler]Time is always against us[/spoiler]