Posted by Dan Guzman on 11/29/06 13:24

> Could you please advice us which technology we should use, such that
> users get the resultset in few seconds.

Pay particular attention to index and query tuning. Make sure you have
indexes that the optimizer can use to generate the most efficient plan.
Prioritize tuning so that the most often executed and expensive queries are
addressed first. Also consider indexed views, which are especially
appropriate for aggregated data. Keep in mind that too many indexes can
hurt performance if you do a lot of inserts/updates so you'll need to
perform cost-benefit analysis.

I suggest you get a good book that covers query and index tuning in depth.
I recommend Inside Microsoft SQL Server 2005: T-SQL Querying, ISBN
9780735623132.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Sathya" <sathyamca@gmail.com> wrote in message
news:1164801200.132687.7070@j72g2000cwa.googlegroups.com...
> We are facing design issues, Could you please advice us how to proceed?
>
> Problem description: Web App will pass a complex dynamic SQL query to
> backend and it should return result set as fast as it can
> Issue 1: SQL query will have lot of JOINS and WHERE clause
> Issue 2: Each Table contain millions of records
>
> Requirement: Turn around time of the SQL query should be as far as
> possible minimum.
>
>
> Could you please advice us which technology we should use, such that
> users get the resultset in few seconds.
>
> We are Microsoft Partner. We use only Microsoft technology for our
> product development.
>
>
> Your Help is much appreciated
>
> With Regards
> S a t h y a R
>

[Back to original message]