speeding up a query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rahul Chatterjee (rahul_at_benesysinc.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 11:01:14 -0500

Hello All

In my database I have multiple tables. I use select information from each of
these tables and insert it into one single table. I then index it up and run
queries on it. The table is dropped each time and recreated and reindexed.
THis process takes relatively less time. The reindexing of the table though
takes a huge amount of time (as there are about 3 million records). Also any
queries that I run on this table (even though the queries include the
appropriate key values) takes long to run. I have four indexes on the table
and I dont think I can insert any more relevant indexes on it.

The queries get called from Crystal Reports 8.5 reports and they take
significant amount of time to execute. What can I do to speed up queries in
general?

Thanks in advance

Relevant Pages

  • Re: speeding up a query
    ... > queries that I run on this table (even though the queries include the ... > and I dont think I can insert any more relevant indexes on it. ... > The queries get called from Crystal Reports 8.5 reports and they take ... > significant amount of time to execute. ...
    (microsoft.public.sqlserver.programming)
  • Re: pause code in a web application?
    ... a script timeout that prevent long running pages etc etc... ... does seem like slowing the web response may not be a solution. ... document that is used in Crystal reports and on the method document.close ... occurs on long queries, were data is processed for several years. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASP.NET and Crystal Reports
    ... I run different kinds of queries and display ... using crystal reports. ...
    (microsoft.public.dotnet.framework.aspnet)