<div>
For starters, post the T-SQL for view vwEvent into this question<br />
<br />
&gt;DECLARE @Date varchar(10) = '3/16/2017'; <br />
Bad developer. &nbsp;Very bad. &nbsp;Why are we storing dates as a varchar? &nbsp; This at minimum forces implicit conversion which adds to query processing time. <br />
<br />
&gt;AND EventParam2 like '%/NameSSN/%'<br />
Lose the LIKE comparison if possible, as these by definition are slow.
</div>


<div>
thank you .could you please make a change to the query .what should i use for date instead of varchar ? are you suggesting something like <br />
<br />
AND EventParam2 like 'NameSSN/%' ?
</div>


<div>
&gt;what should i use for date instead of varchar ? <br />
Use <a href="https://msdn.microsoft.com/en-us/library/ms186724.aspx" rel="ugc">date</a>. &nbsp;This assumes that the EventDate column in your view is a date data type.<br />
<br />
&gt;are you suggesting something like .. AND EventParam2 like 'NameSSN/%' ?<br />
I'm suggesting not using LIKE and a wildcard % of any kind if that is possible.
</div>


<div>
do you think below query is better than original .and any other suggestion please ?<br />
<br />
DECLARE @Date date = '3/16/2017';<br />
DECLARE @Client varchar(50) = 'logix';<br />
<br />
SELECT &nbsp;count(*) AS 'SSN Checks' FROM vwEvent &nbsp;<br />
WHERE EventType= 'SigningPing'<br />
&nbsp;AND EventDate = @Date<br />
&nbsp;AND EventParam4 = @Client<br />
&nbsp;AND EventParam2 = 'NameSSN'
</div>


<div>
after all conversation with JIm Horn got my solution .thank you GURU
</div>


<div>
<div class="content wysiwyg-content">
how could i improve below query performance .in test server it takes more than 2 minutes .In prod busy server( millions of rows ) it will take more time to execute .any good thoghts would help .<br />
<br />
DECLARE @Date varchar(10) = '3/16/2017'; <br />
DECLARE @Client varchar(50) = 'logix'; <br />
SELECT count(*) AS 'SSN Checks' <br />
FROM vwEvent <br />
WHERE EventType = 'SigningPing' <br />
AND EventDate = @Date <br />
AND EventParam4 = @Client <br />
AND EventParam2 like '%/NameSSN/%'<br />
<br />
<br />
thanks all in advance
</div>
</div>


how could i improve below query performance .in test server it takes more than 2 minutes .In prod busy server( millions of rows ) it will take more time to execute .any good thoghts would help .

DECLARE @Date varchar(10) = '3/16/2017'; 
DECLARE @Client varchar(50) = 'logix'; 
SELECT count(*) AS 'SSN Checks' 
FROM vwEvent 
WHERE EventType = 'SigningPing' 
AND EventDate = @Date 
AND EventParam4 = @Client 
AND EventParam2 like '%/NameSSN/%'


thanks all in advance

query optimization

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.