Redundant Indexes?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jorge Luzarraga Castro (jluzarraga_at_fidens.cl)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 10:38:05 -0300

Hello,

I´ve got a table called 'prd_movcomision' (I´ve attached a script with its
structure) which has several indexes as you can see. There are several
indexes which are contained in others. For example:

CREATE INDEX [A] ON [dbo].[prd_movcomision]([pers_rutcia], [poli_codigo],
[itpo_codigo]) ON [PRIMARY]
GO

 CREATE INDEX [B] ON [dbo].[prd_movcomision]([poli_codigo], [itpo_codigo])
ON [PRIMARY]
GO

 CREATE INDEX [C] ON [dbo].[prd_movcomision]([prop_codigo]) ON [PRIMARY]
GO

Given the previous indexes, [B] is contained within [A] and [C] is
contained within [B]. The question is if this is really neccessary or once
I have an index A the other indexes (B and C) are redundant. I´m having too
many problems with the size of the database, it is growing too fast.

Any advice on this would be very much appreciated.

Jorge Luzarraga

begin 666 prd_movcomision.sql
M:68@97AI<W1S("AS96QE8W0@*B!F<F]M(&1B;RYS>7-O8FIE8W1S('=H97)E
M(&ED(#T@;V)J96-T7VED*$XG6V1B;UTN6W!R9%]M;W9C;VUI<VEO;ETG*2!A
M;F0@3T)*14-44%)/4$525%DH:60L($XG27-5<V5R5&%B;&4G*2 ](#$I#0ID
M<F]P('1A8FQE(%MD8F]=+EMP<F1?;6]V8V]M:7-I;VY=#0I'3PT*#0I#4D5!
M5$4@5$%"3$4@6V1B;UTN6W!R9%]M;W9C;VUI<VEO;ET@* T*"5MM;W9C7V-O
M9&EG;UT@6VYU;65R:6-=*#$X+" P*2!.3U0@3E5,3" L#0H)6VUO=F-?9F5C
M;6]V72!;9&%T971I;65=($Y/5"!.54Q,("P-"@E;<&5R<U]R=71C:6%=(%MN
M=6UE<FEC72@Y+" P*2!.54Q,("P-"@E;:6YF:5]C;V1I9V]=(%MV87)C:&%R
M72 H-2D@0T],3$%412!344Q?3&%T:6XQ7T=E;F5R86Q?0U Q7T-)7T%3($Y5
M3$P@+ T*"5MD;V-O7VYU;65R;UT@6VYU;65R:6-=*#$X+" P*2!.54Q,("P-
M"@E;<&]L:5]C;V1I9V]=(%MN=6UE<FEC72@Q."P@,"D@3E5,3" L#0H)6VET
M<&]?8V]D:6=O72!;;G5M97)I8UTH,3@L(# I($Y53$P@+ T*"5ME<W1A7V-O
M9&EG;UT@6VYU;65R:6-=*#0L(# I($Y53$P@+ T*"5MM;VYE7V-O9&EG;UT@
M6V-H87)=("@S*2!#3TQ,051%(%-13%],871I;C%?1V5N97)A;%]#4#%?0TE?
M05,@3D]4($Y53$P@+ T*"5MP<F]P7V-O9&EG;UT@6VYU;65R:6-=*#$X+" P
M*2!.54Q,("P-"@E;:71P<E]C;V1I9V]=(%MN=6UE<FEC72@Q."P@,"D@3E5,
M3" L#0H)6V-O;F5?8V]D:6=O72!;;G5M97)I8UTH,3@L(# I($Y53$P@+ T*
M"5MP<F]P7V9E8V1O8W5M72!;9&%T971I;65=($Y53$P@+ T*"5MP<F]P7V9E
M8V5M:7-I;VY=(%MD871E=&EM95T@3E5,3" L#0H)6W!R;W!?9F5C:6YI8VEO
M72!;9&%T971I;65=($Y53$P@+ T*"5MI='!R7V9E8VEN:6-I;UT@6V1A=&5T
M:6UE72!.54Q,("P-"@E;<&]L:5]F96-E;6ES:6]N72!;9&%T971I;65=($Y5
M3$P@+ T*"5MP;VQI7V9E8VEN:6-I;UT@6V1A=&5T:6UE72!.54Q,("P-"@E;
M:71P;U]F96-I;FEC:6]=(%MD871E=&EM95T@3E5,3" L#0H)6VUO=F-?8V]N
M8V5P=&]=(%MC:&%R72 H,2D@0T],3$%412!344Q?3&%T:6XQ7T=E;F5R86Q?
M0U Q7T-)7T%3($Y53$P@+ T*"5MM;W9C7W1I<&]I;G1E<FU=(%MC:&%R72 H
M,2D@0T],3$%412!344Q?3&%T:6XQ7T=E;F5R86Q?0U Q7T-)7T%3($Y53$P@
M+ T*"5MM;W9C7W!E<FEO9&]=(%MN=6UE<FEC72@V+" P*2!.54Q,("P-"@E;
M;6]V8U]M;W1N;W!A9V]=(%MV87)C:&%R72 H,C4U*2!#3TQ,051%(%-13%],
M871I;C%?1V5N97)A;%]#4#%?0TE?05,@3E5,3" L#0H)6VUO=F-?:6YD8W)I
M=&5R:6]=(%MC:&%R72 H,2D@0T],3$%412!344Q?3&%T:6XQ7T=E;F5R86Q?
M0U Q7T-)7T%3($Y53$P@+ T*"5MM;W9C7W1I<&]=(%MC:&%R72 H,2D@0T],
M3$%412!344Q?3&%T:6XQ7T=E;F5R86Q?0U Q7T-)7T%3($Y53$P@+ T*"5MM
M;W9C7W5N:61A9&-O;5T@6V-H87)=("@Q*2!#3TQ,051%(%-13%],871I;C%?
M1V5N97)A;%]#4#%?0TE?05,@3E5,3" L#0H)6VUO=F-?9FEJ;UT@6VYU;65R
M:6-=*#$X+" T*2!.54Q,("P-"@E;;6]V8U]V87)I86)L95T@6VYU;65R:6-=
M*#<L(#,I($Y53$P@+ T*"5MM;W9C7W!R:6UA72!;;G5M97)I8UTH,3@L(#0I
M($Y53$P@+ T*"5MM;W9C7VUO;G1O;6]=(%MN=6UE<FEC72@Q."P@-"D@3D]4
M($Y53$P@+ T*"5MM;W9C7VUO;G1O;6-=(%MN=6UE<FEC72@Q."P@-"D@3E5,
M3" L#0H)6VUO=F-?9F5C=F%L;W)=(%MD871E=&EM95T@3E5,3" L#0H)6VUO
M=F-?9F5C8VEE<G)E72!;9&%T971I;65=($Y53$P@+ T*"5MM;W9C7V]B<V5R
M=F%C:6]N72!;=F%R8VAA<ET@*#(U-2D@0T],3$%412!344Q?3&%T:6XQ7T=E
M;F5R86Q?0U Q7T-)7T%3($Y53$P@+ T*"5MM;W9C7W1I<&]R86YG;UT@6V-H
M87)=("@Q*2!#3TQ,051%(%-13%],871I;C%?1V5N97)A;%]#4#%?0TE?05,@
M3E5,3" L#0H)6V-I97)?=&EP;UT@6V-H87)=("@Q*2!#3TQ,051%(%-13%],
M871I;C%?1V5N97)A;%]#4#%?0TE?05,@3E5,3" L#0H)6V-I97)?8V]R<F5L
M871I=F]=(%MN=6UE<FEC72@Q."P@,"D@3E5,3" L#0H)6V-U;W1?8V]D:6=O
M72!;;G5M97)I8UTH,3@L(# I($Y53$P@+ T*"5MC=6]T7VYU;65R;UT@6VYU
M;65R:6-=*#0L(# I($Y53$P@+ T*"5MM;W9C7V9E8VUE=&%=(%MD871E=&EM
M95T@3E5,3" L#0H)6VUO=F-?<')I;6%N971A72!;=%]D;VU?;6]N=&]=($Y5
M3$P@+ T*"5MM;W9C7V9E8W!A9V]C;VUI<UT@6W1?9&]M7V9E8VAA72!.54Q,
M( T**2!/3B!;4%))34%265T-"D=/#0H-"D%,5$52(%1!0DQ%(%MD8F]=+EMP
M<F1?;6]V8V]M:7-I;VY=(%=)5$@@3D]#2$5#2R!!1$0@#0H)0T].4U1204E.
M5"!;<&M?;6]V8V]M:7-I;VY=(%!224U!4ED@2T59("!#3%535$52140@#0H)
M* T*"0E;;6]V8U]C;V1I9V]=#0H)*2 @3TX@6U!224U!4EE=( T*1T\-"@T*
M($-214%412 @24Y$15@@6T%+7W!R9%]M;W9C;VUI<VEO;ET@3TX@6V1B;UTN
M6W!R9%]M;W9C;VUI<VEO;ETH6VUO=F-?=&EP;VEN=&5R;5TL(%MP97)S7W)U
M=&-I85TL(%MM;W9C7V-O;F-E<'1O72P@6V-O;F5?8V]D:6=O72P@6W!O;&E?
M8V]D:6=O72D@3TX@6U!224U!4EE=#0I'3PT*#0H@0U)%051%("!)3D1%6"!;
M06E?<')D7VUO=F-O;6ES:6]N,ET@3TX@6V1B;UTN6W!R9%]M;W9C;VUI<VEO
M;ETH6W!E<G-?<G5T8VEA72P@6W!O;&E?8V]D:6=O72P@6VET<&]?8V]D:6=O
M72D@3TX@6U!224U!4EE=#0I'3PT*#0H@0U)%051%("!)3D1%6"!;25A?<')D
M7VUO=F-O;6ES:6]N72!/3B!;9&)O72Y;<')D7VUO=F-O;6ES:6]N72A;<&]L
M:5]C;V1I9V]=+"!;:71P;U]C;V1I9V]=*2!/3B!;4%))34%265T-"D=/#0H-
M"B!#4D5!5$4@($E.1$58(%M)6%]P<F1?;6]V8V]M:7-I;VXQ72!/3B!;9&)O
M72Y;<')D7VUO=F-O;6ES:6]N72A;<')O<%]C;V1I9V]=*2!/3B!;4%))34%2
M65T-"D=/#0H-"B!#4D5!5$4@($E.1$58(%M)6%]P<F1?;6]V8V]M:7-I;VXR
M72!/3B!;9&)O72Y;<')D7VUO=F-O;6ES:6]N72A;<&]L:5]C;V1I9V]=*2!/
M3B!;4%))34%265T-"D=/#0H-"B\J*BHJ*BH@5&AE(&EN9&5X(&-R96%T960@
M8GD@=&AE(&9O;&QO=VEN9R!S=&%T96UE;G0@:7,@9F]R(&EN=&5R;F%L('5S
M92!O;FQY+B J*BHJ*BHO#0HO*BHJ*BHJ($ET(&ES(&YO="!A(')E86P@:6YD
M97@@8G5T(&5X:7-T<R!A<R!S=&%T:7-T:6-S(&]N;'DN("HJ*BHJ*B\-"FEF
M("A 0&UI8W)O<V]F='9E<G-I;VX@/B P># W,# P,# P("D-"D5814,@*"=#
M4D5!5$4@4U1!5$E35$E#4R!;4W1A=&ES=&EC7VUO=F-?9F5C<&%G;V-O;6ES
M72!/3B!;9&)O72Y;<')D7VUO=F-O;6ES:6]N72 H6VUO=F-?9F5C<&%G;V-O
M;6ES72D@)RD-"D=/#0H-"D%,5$52(%1!0DQ%(%MD8F]=+EMP<F1?;6]V8V]M
M:7-I;VY=($%$1" -"@E#3TY35%)!24Y4(%MF:U]R7V-O;F5?;6]V8V]M72!&
M3U)%24=.($M%62 -"@DH#0H)"5MC;VYE7V-O9&EG;UT-"@DI(%)%1D5214Y#
M15,@6V1B;UTN6W!R9%]C;VUN96=O8VEO72 H#0H)"5MC;VYE7V-O9&EG;UT-
M"@DI+ T*"4-/3E-44D%)3E0@6V9K7W)?8W5O=%]M;W9C;VU=($9/4D5)1TX@
M2T59( T*"2@-"@D)6V-U;W1?8V]D:6=O72P-"@D)6V-U;W1?;G5M97)O70T*
M"2D@4D5&15)%3D-%4R!;9&)O72Y;<')D7V-U;W1A72 H#0H)"5MC=6]T7V-O
M9&EG;UTL#0H)"5MC=6]T7VYU;65R;UT-"@DI+ T*"4-/3E-44D%)3E0@6V9K
M7W)?9&]C8V]M7VUO=F-O;5T@1D]214E'3B!+15D@#0H)* T*"0E;<&5R<U]R
M=71C:6%=+ T*"0E;:6YF:5]C;V1I9V]=+ T*"0E;9&]C;U]N=6UE<F]=#0H)
M*2!2149%4D5.0T53(%MD8F]=+EMP<F1?9&]C8V]M:7-I;VY=("@-"@D)6W!E
M<G-?<G5T8VEA72P-"@D)6VEN9FE?8V]D:6=O72P-"@D)6V1O8V]?;G5M97)O
M70T*"2DL#0H)0T].4U1204E.5"!;9FM?<E]E<W1?;6]V8V]M72!&3U)%24=.
M($M%62 -"@DH#0H)"5ME<W1A7V-O9&EG;UT-"@DI(%)%1D5214Y#15,@6V1B
M;UTN6V%D;5]E<W1A9&]=("@-"@D)6V5S=&%?8V]D:6=O70T*"2DL#0H)0T].
M4U1204E.5"!;9FM?<E]E<W1C:65R7VUO=F-O;5T@1D]214E'3B!+15D@#0H)
M* T*"0E;;6]V8U]P97)I;V1O72P-"@D)6V-I97)?=&EP;UTL#0H)"5MC:65R
M7V-O<G)E;&%T:79O70T*"2D@4D5&15)%3D-%4R!;9&)O72Y;<')D7V5S=&%D
M;V-I97)R95T@* T*"0E;8VEE<E]P97)I;V1O72P-"@D)6V-I97)?=&EP;UTL
M#0H)"5MC:65R7V-O<G)E;&%T:79O70T*"2DL#0H)0T].4U1204E.5"!;9FM?
M<E]I=&UP<E]M;W9C;VU=($9/4D5)1TX@2T59( T*"2@-"@D)6W!R;W!?8V]D
M:6=O72P-"@D)6VET<')?8V]D:6=O70T*"2D@4D5&15)%3D-%4R!;9&)O72Y;
M=G1A7VET;7!R;W!U97-T85T@* T*"0E;<')O<%]C;V1I9V]=+ T*"0E;:71P
M<E]C;V1I9V]=#0H)*2P-"@E#3TY35%)!24Y4(%MF:U]R7VUN9%]M;W9C;VU=
M($9/4D5)1TX@2T59( T*"2@-"@D)6VUO;F5?8V]D:6=O70T*"2D@4D5&15)%
M3D-%4R!;9&)O72Y;861M7VUO;F5D85T@* T*"0E;;6]N95]C;V1I9V]=#0H)
M*0T*1T\-"@T*86QT97(@=&%B;&4@6V1B;UTN6W!R9%]M;W9C;VUI<VEO;ET@
M;F]C:&5C:R!C;VYS=')A:6YT(%MF:U]R7V5S=%]M;W9C;VU=#0I'3PT*#0IA
M;'1E<B!T86)L92!;9&)O72Y;<')D7VUO=F-O;6ES:6]N72!N;V-H96-K(&-O
M;G-T<F%I;G0@6V9K7W)?97-T8VEE<E]M;W9C;VU=#0I'3PT*#0IA;'1E<B!T
M86)L92!;9&)O72Y;<')D7VUO=F-O;6ES:6]N72!N;V-H96-K(&-O;G-T<F%I
M;G0@6V9K7W)?:71M<')?;6]V8V]M70T*1T\-"@T*86QT97(@=&%B;&4@6V1B
M;UTN6W!R9%]M;W9C;VUI<VEO;ET@;F]C:&5C:R!C;VYS=')A:6YT(%MF:U]R
47VUN9%]M;W9C;VU=#0I'3PT*#0H`
`
end

Relevant Pages

  • Comparison Script Components with Script Classes
    ... Now I would like to have some advice from more experienced programmers. ... I do not really figure out, how the concepts of Script Components and Script Classes differ and for what use cases they are intended. ... How do you build your strictly object-oriented libraries in VBScript? ...
    (microsoft.public.scripting.vbscript)
  • Re: Using $_POST with Submit button
    ... > I wondered if anyone could further advice? ... In my script I was ... are both on the same script, this is the way of detecting when $_POST ... Visit Topic URL to contact author (reg. ...
    (comp.lang.php)
  • Re: Trouble with system() function
    ... > Thanks for the advice. ... if I run that part of the script from the command ... can't guarantee it. ... / without MD5 usage) from my example instead of your code you have ...
    (comp.lang.php)
  • Re: ksh: Copying files one by one
    ... Thanks for misc. ... I first implemented using Bill's advice, ... advice by Markus and Chris. ... Even though my script is still a bit buggy, ...
    (comp.unix.shell)
  • BUG? IE6 Windows XP SP2: iexplore.exe ram is growing and growing...
    ... I have Windows XP SP2 installed and I am wondering using a short javascript ... the ram used by iexplore.exe is growing and growing. ... will have about 100% cpu usage. ... Another script error occured on a different script: ...
    (microsoft.public.windows.inetexplorer.ie6.browser)