Re: indexes on tables that get dropped?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tenaya (ct_at_ct.ct)
Date: 04/09/04 

Date: Fri, 9 Apr 2004 10:18:07 -0400

Adria,

Perhaps you can recommend to your client that instead of a DROP / CREATE
scenario, that they use the TRUNCATE TABLE option to quickly remove data
from the table while preserving the structure of the table. This way index
structures would be also preserved.

Chief Tenaya

"Adria" <a-carbo@tamu.edu> wrote in message
news:17a7601c41e39$aa2e32a0$a601280a@phx.gbl...
> I have a client who is experiencing performance problems
> due to a very complex query. We would like to create an
> index (or two) to help speed up the query. However, the
> table on which the query is based is dropped and re-
> created hourly.
>
> Would creating an index be advantageous or not?
>
> TIA,
> Adria

Relevant Pages

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete Query Does Not
    ... When I try to run the SQL query below it gives me the ... Cannot group on fields selected with '*' (client) ... INNER JOIN meals ... Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Report filtered on a calculated field
    ... Make a query to determine who owes you. ... make this into a Totals Query. ... now you can base your first report directly on this query. ... totals for each client, also define a Client footer section as well. ...
    (microsoft.public.access.reports)