querry execution takes too long
-
Hi, I execute the following querry in querry analyser and it takes more than 2 minutes to complete the execution. this is the querry select * from tablename table has 155000 records and it is indexed. is it a common one or does the sql server requires any tuning adjustments. pls help srinivasan
-
Hi, I execute the following querry in querry analyser and it takes more than 2 minutes to complete the execution. this is the querry select * from tablename table has 155000 records and it is indexed. is it a common one or does the sql server requires any tuning adjustments. pls help srinivasan
-
Hi, I execute the following querry in querry analyser and it takes more than 2 minutes to complete the execution. this is the querry select * from tablename table has 155000 records and it is indexed. is it a common one or does the sql server requires any tuning adjustments. pls help srinivasan
Depending on your settings in the analyzer, queries can tak a lot longer than when running from a normal client... Maybe the server needs more memory/cpu maybe the disks are too slow maybe the server have way too much other work to do It's a hard question to answar without knowing a lot about the system... - Anders Money talks, but all mine ever says is "Goodbye!"