Re: Cluster indexing time increasing each week
From: JXStern (JXSternChangeX2R_at_gte.net)
Date: 01/04/05
- Next message: Aaron Bertrand [MVP]: "Re: IIF Function"
- Previous message: Raghib: "IIF Function"
- In reply to: Don: "Cluster indexing time increasing each week"
- Next in thread: AnthonyThomas: "Re: Cluster indexing time increasing each week"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 03 Jan 2005 17:46:19 -0800
On Mon, 3 Jan 2005 10:19:23 -0800, "Don"
<anonymous@discussions.microsoft.com> wrote:
>SQL 7.0
>There's a table with 100M records (and growing) that's
>needing to be reindexed every week. If I don't recreate
>the index, the fragmentation causes performance of the
>queries to get slower and slower. I have a job that runs
>the following script, but it's taking a little longer
>each week and I'm wondering if there's a way to speed it
>up...
Are these SELECT queries or INSERT, UPDATE, or DELETE, and whichever,
do they reference the clustered index?
If the file grows each week then yes, it is going to take a little
longer every week.
Maybe you should look into partitioned tables?
J.
- Next message: Aaron Bertrand [MVP]: "Re: IIF Function"
- Previous message: Raghib: "IIF Function"
- In reply to: Don: "Cluster indexing time increasing each week"
- Next in thread: AnthonyThomas: "Re: Cluster indexing time increasing each week"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
