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
 General SQL Server Forums
 New to SQL Server Programming
 SQL Speed

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-09-19 : 07:40:56
Andy writes "I have data with more than 4 milions. How to speed up query it ?"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 07:59:32
Use proper INDEX. If you can afford, use a covered INDEX.



Peter Larsson
Helsingborg, Sweden
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-19 : 08:00:23
Whoa!!

That's too much information!!!

Post the query you want to speed up along with table structures, index information etc.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-09-19 : 08:04:18
"How to speed up query it"

How long does it take?

How long would you like it to take?

What does it do?

Kristen
Go to Top of Page
   

- Advertisement -