<div>
The very first thing to check: do you have indexes on all of the columns used in joins and in your WHERE clause?If you are using a WHERE clause, what is it?
</div>


The very first thing to check: do you have indexes on all of the columns used in joins and in your WHERE clause?If you are using a WHERE clause, what is it?

<div>
Yes there is where clauses which is used for filtering basically<br />

</div>


Yes there is where clauses which is used for filtering basically


<div>
for example <br />
where a.x = @clientID<br />
and b.y between @StartDate and @EndDate
</div>


for example
where a.x = @clientID
and b.y between @StartDate and @EndDate

<div>
can you provide your real query?<br />
(you may change table name/field list to something else to hide it real name, if u want to)<br />
so we can see if some table can be remove or not<br />
<br />
since now, we can't see which field need to be retrieve, which field need to be filter etc.<br />

</div>


can you provide your real query?
(you may change table name/field list to something else to hide it real name, if u want to)
so we can see if some table can be remove or not

since now, we can't see which field need to be retrieve, which field need to be filter etc.


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have got a SQL Query to improve it's performance.<br />
<br />
Here is simple format of how it is structured:<br />
<br />
Select x,y,z from table a<br />
inner join table b on a.id = b.id<br />
inner jon table c on b.id = c.id<br />
inner join table d on a.id = d.id<br />
<br />
left join table w.........<br />
left join &nbsp;table y.........<br />
left jon table z.........<br />
left join table q.........<br />
left join table p.........<br />
<br />
how can this change to produce a faster query...<br />
<br />
thanks in advance
</div>
</div>


Hi,

I have got a SQL Query to improve it's performance.

Here is simple format of how it is structured:

Select x,y,z from table a
inner join table b on a.id = b.id
inner jon table c on b.id = c.id
inner join table d on a.id = d.id

left join table w.........
left join  table y.........
left jon table z.........
left join table q.........
left join table p.........

how can this change to produce a faster query...

thanks in advance

sql server 2005

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.