I have a query, that is being ran against 21 million rows in the view
v_add_remove_programs, that is slower then "expected". I've seen John Nelson's
post here:
http://myitforum.com/cs2/blogs/jnelson/archive/2007/11/16/108354.aspx - which
is awesome!
Is there any way to optimize this simple query?
(I've had the customer add additional temdb files and we've seen some
performance gains with that)
·
The query
we used as a baseline for our test:
select distinct DisplayName0
from v_Add_Remove_Programs arp where arp.DisplayName0 like '%Application
Virtualization Desktop%'
This query takes, about 14 seconds to run against 21 million rows
·
When we
re-write the query, like so:
select distinct DisplayName0
from v_Add_Remove_Programs arp where arp.DisplayName0 like '%Application
Virtualization Desktop'
The query takes, about 1 second to run against 21 million
Any input from SQL guru's would be awesome!
Mike D-
