Selecting from a Large Table SQL 2005
Posted
by Eugene
on Stack Overflow
See other posts from Stack Overflow
or by Eugene
Published on 2010-04-19T23:28:00Z
Indexed on
2010/04/19
23:33 UTC
Read the original article
Hit count: 170
Filed under:
sql
I have a SQL table it has more than 1000000 rows, and I need to select with the query as you can see below:
SELECT DISTINCT TOP (200) COUNT(1) AS COUNT, KEYWORD FROM QUERIES WITH(NOLOCK) WHERE KEYWORD LIKE '%Something%' GROUP BY KEYWORD ORDER BY 'COUNT' DESC
Could you please tell me how can I optimize it to speed up the execution process? Thank you for useful answers.
© Stack Overflow or respective owner
