sindbad7000 (11/5/2009)
please i am using sql server 2005, i wrote a simple query that joins only 4 tables. 2 of them have thousands of records. the query returns 4500 records in 1 minute and 30 seconds...is that acceptable??
Nope... not acceptable. But can't help because there's not enough info. Please see the second link in my signature line below to get better help.
--Jeff Moden
Change is inevitable... Change for the better is not.