Home Forums SQL Server 7,2000 T-SQL Joining tables RE: Joining tables
Stephen Norrod
SSC Veteran
Points: 280
More actions
August 27, 2004 at 7:48 am
#520866
The problem is indexes then. Either create or check the health of the indexes on "Calls.JOB_NUMBER", "VISITS.JOB_NUMBER", "VISITS.VISIT_NUMBER". Unless you are on a very slow box this should in 1-2 seconds.