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 2000 Forums  SQL Server Development (2000)  performance help with Query

Author  Topic  hmusa Starting Member 36 Posts Posted - 2001-04-30 : 07:23:48 I am running three, basic, very similar queries but all are taking over two munitutes to run Can anyone help in optimising them. here are the queries: Update 1 UPDATE stmbiogr SET geolocn_code = coll_sgen2 from stmgcode where stmbiogr.student_id = stmgcode.student_id and geolocn_code is null update 2 UPDATE stmbiogr SET stmbiogr.geolocn_code = "F" from stmbiogr, stmqustu WHERE stmbiogr.student_id = stmqustu.qls_id and geolocn_code Is Not Null Update 3 UPDATE stmbiogr SET geolocn_code = campus_code from stmucas1 where stmbiogr.student_id = stmucas1.student_id and geolocn_code is null Thanks in advance