3-Way Table Join....Running sloowwww, Any ideas?? - telnet.cap (1/1)
Posted in 1996
Topics: SQL Development & Query Writing
begin 644 telnet.cap M9S(P-#0P,C(Z:6YF;W)M:7@@8V%T(&5T<W0N<V-H#0IC870Z(&-A;FYO="!O M<&5N(&5T<W0N<V-H.B!.;R!S=6-H(&9I;&4@;W(@9&ER96-T;W)Y#0H-"F<R M,#0T,#(R.FEN9F]R;6EX(&-A="!T97-T+G-C:`T*>R!404),12`B8G=Z<G1T M<R(N9F]C9F%X8V-N82!R;W<@<VEZ92`](#$W-R!N=6UB97(@;V8@8V]L=6UN M<R`](#$P(&EN9&5X('-I>F4@/2`-"C$X,R`-"B`@("`@("`@("`@("`@?0T* M>R!U;FQO860@9FEL92!N86UE(#T@9F]C9F%X8S$P,"YU;FP@;G5M8F5R(&]F M(')O=W,@/2`Q('T-"@T*8W)E871E('1A8FQE(")B=WIR='1S(BYF;V-F87AC M8VYA(`T*("`H#0H@("`@8V-N82!C:&%R*#,I(&YO="!N=6QL(&-O;G-T<F%I M;G0@(F)W>G)T=',B+FXQ,#!?,BP-"B`@("!I8W-C(&-H87(H-"D@;F]T(&YU M;&P@8V]N<W1R86EN="`B8G=Z<G1T<R(N;C$P,%\\S+`T*("`@(&-O;7!N86UE M(&-H87(H,C4I(&YO="!N=6QL(&-O;G-T<F%I;G0@(F)W>G)T=',B+FXQ,#!? M-"P-"B`@("!D969F87AN=6T@8VAA<B@Q-2DL#0H@("`@<W!E8V9A>&YU;2!C M:&%R*#$U*2P-"B`@("!M97-S9F%X;G5M(&-H87(H,34I+`T*("`@(&-O;G1N M86UO;F4@8VAA<B@R-2DL#0H@("`@8V]N=&YA;71W;R!C:&%R*#(U*2P-"B`@ M("!C;VYT;F%M=&AR964@8VAA<B@R-2DL#0H@("`@8V]N=&YA;69O=7(@8VAA M<B@R-2DL#0H@("`@<')I;6%R>2!K97D@*&-C;F$L:6-S8RD@8V]N<W1R86EN M="`B8G=Z<G1T<R(N=3$P,%\\Q#0H@("D@97AT96YT('-I>F4@,38@;F5X="!S M:7IE(#$V(&QO8VL@;6]D92!P86=E.PT*#0IC<F5A=&4@:6YD97@@(F)W>G)T M=',B+F9O8V9A>&-C;F%?:61X(&]N(")B=WIR='1S(BYF;V-F87AC8VYA("AC M8VYA+&EC<V,L8V]N=&YA;0T*;VYE+`T*("`@(&-O;G1N86UT=V\\L8V]N=&YA M;71H<F5E+&-O;G1N86UF;W5R*3L-"GL@5$%"3$4@(F)W>G)T=',B+F9O8VUA M:6QE<B!R;W<@<VEZ92`](#0Y-2!N=6UB97(@;V8@8V]L=6UN<R`](#$X(&EN M9&5X('-I>F4@/2`Q#0HT."`-"B`@("`@("`@("`@("`@?0T*>R!U;FQO860@ M9FEL92!N86UE(#T@9F]C;6%I;#$P,2YU;FP@;G5M8F5R(&]F(')O=W,@/2`X M.3DQ('T-"@T*8W)E871E('1A8FQE(")B=WIR='1S(BYF;V-M86EL97(@#0H@ M("@-"B`@("!A<W(@8VAA<B@Q,"D@;F]T(&YU;&P@8V]N<W1R86EN="`B8G=Z M<G1T<R(N;C$P,5\\V+`T*("`@(&1A=&4@8VAA<B@V*2!N;W0@;G5L;"!C;VYS M=')A:6YT(")B=WIR='1S(BYN,3`Q7S<L#0H@("`@<F5Q7W-T<FEN9R!C:&%R M*#4P*2P-"B`@("!R97%I9"!C:&%R*#0I+`T*("`@(&1E<W0@8VAA<B@Q,"DL M#0H@("`@871T96UP=',@:6YT96=E<BP-"B`@("!D:6%L<W1R:6YG(&-H87(H M,C4I+`T*("`@(&-S:2!C:&%R*#,P*2P-"B`@("!N<&%G97,@:6YT96=E<BP- M"B`@("!N86MS(&EN=&5G97(L#0H@("`@85]R97-U;'0@8VAA<B@X*2P-"B`@ M("!R7W)E<W5L="!C:&%R*#@I+`T*("`@('1A9S$@8VAA<B@R-2DL#0H@("`@ M=&%G,B!C:&%R*#(U*2P-"B`@("!M971H;V0@8VAA<B@X*2P-"B`@("!O<'1I M;VYS(&-H87(H,C4V*2P-"B`@("!M86EL7W1Y<&4@8VAA<B@X*2P-"B`@("!T M:6UE<W1A;7`@9&%T971I;64@>65A<B!T;R!F<F%C=&EO;B@S*2!N;W0@;G5L M;"!C;VYS=')A:6YT(")B=WIR='1S(BYN,3`Q7S@L#0H@("`@<')I;6%R>2!K M97D@*&%S<BQD871E+'1I;65S=&%M<"D@8V]N<W1R86EN="`B8G=Z<G1T<R(N M=3$P,5\\U#0H@("D@97AT96YT('-I>F4@,38@;F5X="!S:7IE(#$V(&QO8VL@ M;6]D92!P86=E.PT*#0IC<F5A=&4@:6YD97@@(F)W>G)T=',B+F9O8VUA:6QE M<E]I9'@@;VX@(F)W>G)T=',B+F9O8VUA:6QE<B`H=&EM97-T86UP+&%S<BQA M='1E;0T*<'1S+`T*("`@(&1I86QS=')I;F<L85]R97-U;'0L<E]R97-U;'0I M.PT*>R!404),12`B8G=Z<G1T<R(N9F]C9V5N97)A=&]R(')O=R!S:7IE(#T@ M,C$W(&YU;6)E<B!O9B!C;VQU;6YS(#T@,34@:6YD97@@<VEZ92`-"CT@#0H@ M("`@("`@("`@("`@(#,S,R!]#0I[('5N;&]A9"!F:6QE(&YA;64@/2!F;V-G M96YE,3`R+G5N;"!N=6UB97(@;V8@<F]W<R`](#DY.2!]#0H-"F-R96%T92!T M86)L92`B8G=Z<G1T<R(N9F]C9V5N97)A=&]R(`T*("`H#0H@("`@8V-N82!C M:&%R*#,I(&YO="!N=6QL(&-O;G-T<F%I;G0@(F)W>G)T=',B+FXQ,#)?,3`L M#0H@("`@:6-S8R!C:&%R*#0I(&YO="!N=6QL(&-O;G-T<F%I;G0@(F)W>G)T M=',B+FXQ,#)?,3$L#0H@("`@<&]N(&-H87(H,38I+`T*("`@(&%S<B!C:&%R M*#$P*2!N;W0@;G5L;"!C;VYS=')A:6YT(")B=WIR='1S(BYN,3`R7S$R+`T* M("`@(&1A=&4@8VAA<B@V*2P-"B`@("!D9&%T92!C:&%R*#8I+`T*("`@(&EN M:71I871O<B!C:&%R*#$U*2P-"B`@("!D871E=&EM97-T(&1A=&5T:6UE('EE M87(@=&\\@9G)A8W1I;VXH,RD@;F]T(&YU;&P@8V]N<W1R86EN="`B8G=Z<G1T M<R(N;C$P,E\\Q#0HS+`T*("`@(&UA8VAN86UE(&-H87(H,34I(&YO="!N=6QL M(&-O;G-T<F%I;G0@(F)W>G)T=',B+FXQ,#)?,30L#0H@("`@<&%T:&YA;64@ M8VAA<B@V,"D@;F]T(&YU;&P@8V]N<W1R86EN="`B8G=Z<G1T<R(N;C$P,E\\Q M-2P-"B`@("!F:6QE;F%M92!C:&%R*#0P*2!N;W0@;G5L;"!C;VYS=')A:6YT M(")B=WIR='1S(BYN,3`R7S$V+`T*("`@(&9A>&YU;6)E<B!C:&%R*#$U*2P- M"B`@("!E<G)O<G1Y<&4@:6YT96=E<B!N;W0@;G5L;"!C;VYS=')A:6YT(")B M=WIR='1S(BYN,3`R7S$W+`T*("`@(&)A;B!C:&%R*#$R*2P-"B`@("!C;',@ M8VAA<B@Q*2P-"B`@("!P<FEM87)Y(&ME>2`H8V-N82QI8W-C+&%S<BQD871E M=&EM97-T*2!C;VYS=')A:6YT(")B=WIR='1S(BYU,3`R7SD-"B`@*2!E>'1E M;G0@<VEZ92`Q-B!N97AT('-I>F4@,38@;&]C:R!M;V1E('!A9V4[#0H-"F-R M96%T92!I;F1E>"`B8G=Z<G1T<R(N9F]C9V5N97)A=&]R7VED>"!O;B`B8G=Z M<G1T<R(N9F]C9V5N97)A=&]R("AC8VYA+&EC<V,L#0H@("`@87-R+&1A=&5T M:6UE<W0L97)R;W)T>7!E+'!O;BQD871E+&1D871E+&UA8VAN86UE+'!A=&AN M86UE+`T*("`@(&9I;&5N86UE+&)A;BQC;',I.PT*4T5,14-4($9O8T9A>$-# M3D$N8V-N82P-"B`@("`@("!&;V-&87A#0TY!+FEC<V,L#0H@("`@("`@1F]C M1F%X0T-.02YC;VYT;F%M;VYE+`T*("`@("`@($9O8T9A>$-#3D$N8V]N=&YA M;71W;RP-"B`@("`@("!&;V-&87A#0TY!+F-O;G1N86UT:')E92P-"B`@("`@ M("!&;V-&87A#0TY!+F-O;G1N86UF;W5R+`T*("`@("`@($9O8T=E;F5R871O M<BYP;VXL#0H@("`@("`@1F]C1V5N97)A=&]R+F%S<BP-"B`@("`@("!&;V-' M96YE<F%T;W(N9&%T92P-"B`@("`@("!&;V-'96YE<F%T;W(N9&1A=&4L#0H@ M("`@("`@1F]C1V5N97)A=&]R+FUA8VAN86UE+`T*("`@("`@($9O8T=E;F5R M871O<BYP871H;F%M92P-"B`@("`@("!&;V-'96YE<F%T;W(N9FEL96YA;64L M#0H@("`@("`@1F]C1V5N97)A=&]R+F)A;BP-"B`@("`@("!&;V-'96YE<F%T M;W(N8VQS+`T*("`@("`@($9O8T=E;F5R871O<BYE<G)O<G1Y<&4L#0H@("`@ M("`@1F]C36%I;&5R+F%T=&5M<'1S+`T*("`@("`@($9O8TUA:6QE<BYA7W)E M<W5L="P-"B`@("`@("!&;V--86EL97(N<E]R97-U;'0L#0H@("`@("`@1F]C M36%I;&5R+G1I;65S=&%M<"P-"B`@("`@("!&;V--86EL97(N9&EA;'-T<FEN M9R`-"D923TT@1F]C1F%X0T-.02Q&;V-'96YE<F%T;W(L1F]C36%I;&5R(`T* M5TA%4D4@*$9O8T9A>$-#3D$N0V-N82`]($9O8T=E;F5R871O<BY#8VYA(`T* M04Y$("`@1F]C1F%X0T-.02Y)8W-C(#T@1F]C1V5N97)A=&]R+DEC<V,@#0I! M3D0@("`H1F]C36%I;&5R+D%S<B`]($9O8T=E;F5R871O<BY!<W(@3U(@1F]C M36%I;&5R+D%S<CTP,#`P,#`P,#`P*2D-"B`@04Y$("@H*$9O8T=E;F5R871O M<BY$871E5&EM95-T(#X]("<Y-2TQ,BTR-R`Q,SHQ,CHU-BXP,#`G*0T*04Y$ M("`@("`H1F]C1V5N97)A=&]R+D1A=&54:6UE4W0@/#T@)SDU+3$R+3(X(#$S M.C$R.C4V+C`P,"<I*0T*3U(@("`@("@H1F]C36%I;&5R+G1I;65S=&%M<"`^ M/2`G.34M,3(M,C<@,3,Z,3(Z-38N,#`P)RD-"D%.1"`@("`@*$9O8TUA:6QE M<BYT:6UE<W1A;7`@/#T@)SDU+3$R+3(X(#$S.C$R.C4V+C`P,"<I*2D-"D]2 M1$52($)9($9O8T=E;F5R871O<BYE<G)O<G1Y<&4@05-#+`T*("`@("`@("`@ M1F]C1F%X0T-.02YC8VYA($%30RP-"B`@("`@("`@($9O8T9A>$-#3D$N:6-S M8R!!4T,[#0H-"@T*455%4EDZ#0HM+2TM+2T-"E-%3$5#5"!&;V-&87A#0TY! M+F-C;F$L#0H@("`@("`@1F]C1F%X0T-.02YI8W-C+`T*("`@("`@($9O8T9A M>$-#3D$N8V]N=&YA;6]N92P-"B`@("`@("!&;V-&87A#0TY!+F-O;G1N86UT M=V\\L#0H@("`@("`@1F]C1F%X0T-.02YC;VYT;F%M=&AR964L#0H@("`@("`@ M1F]C1F%X0T-.02YC;VYT;F%M9F]U<BP-"B`@("`@("!&;V-'96YE<F%T;W(N M<&]N+`T*("`@("`@($9O8T=E;F5R871O<BYA<W(L#0H@("`@("`@1F]C1V5N M97)A=&]R+F1A=&4L#0H@("`@("`@1F]C1V5