Re: select statement run very slow after installing sp3
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 07/02/04
- Next message: eNerGiZer1010: "Technical questions"
- Previous message: new: "select statement run very slow after installing sp3"
- In reply to: new: "select statement run very slow after installing sp3"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 18:36:28 +0530
Hi,
Check the tables inside the table is fragmented using the command DBCC
SHOWCONTG (refer books online).
If it is fragmented execute DBCC DBREINDEX or DBCC INDEXDEFRAG to remove
fragmentation
-- Thanks Hari MCDBA "new" <anonymous@discussions.microsoft.com> wrote in message news:2527801c46032$92e06fb0$a301280a@phx.gbl... > Select statement is running 3 time slower than before > after I installed sp3 in SQL 2000.(before is sp1). > Do anyone know why and how to fix it? > Thanks all reply.
- Next message: eNerGiZer1010: "Technical questions"
- Previous message: new: "select statement run very slow after installing sp3"
- In reply to: new: "select statement run very slow after installing sp3"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
