Plan Viz.pdf

8/18/2019 Plan Viz.pdf

1/41

!"#$% '#((#$#)#*+ ,!' -!.! /01

.02 34+ 4536

!"# %&'( ) *+,#-+# ./ !0-,-1 2%3% 4.5#6(/.& 7#&/.&48-+#


2/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4'D":%<

9,(+68,4#&

EA%B >8;B;$(#(%0$ 0D(:%$;B 0D8 @;$;8#: >80CD 08 8;:;#B; #$) 9D$8;B;$(#(%0$? EA%B

>8;B;$(#(%0$ #$C ,!'HB B(8#(;@) #$C >0BB%":; 9D(D8; C;2;:0>=;$(B #8; BD"F;0$B%"%:%()

908 ;8808B 08 0=%BB%0$B %$ (A%B C0


3/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? K'D":%<

*%7 2%3%: !"# 768'/.&4 /.& %66 %;;6,+8',.-(

,!' -!.! 'L!EMNOPN.J'O1PQ,1 R /LNST R -UVOQT

W;" ,;82;8 X#2#,(

M%08% SY Z8#>A%<

P0C;:;8

T#(# [%8(D#:%\#(%0$ 1LE ]

O;>:%>:%


4/41


5/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 6'D":%<

?"8'@( A.5#6 7#&/.&48-+#B

` *CD C0#&E

` C0#&E F0- !,4#

` A#4.&E G(81#

` H7G G(81#

` H.-+0&-+E


6/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? a'D":%<

` 9E-84,+ 4#4.&E I8' 6#8(' JKLM

` N-.01" H7G IOP +.QRSTM

` *,-16# -.5# =(U *+86#V.0'

` *,-16#QA06',V!#-8-' I*"8M

` H6.05 =(U W-V;,(#

?"8'@( 0-5#& '"# "..5 ,U#U 2.&(# 7.>#&B


7/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? b'D":%<

` %-86E(,( ./ *CD X0#&E

` Y,(086 >86Z'"&.01" ./ 4.5#6

` N[;68,- ;68- I#-1,-# 0(#5M

` Y,(086,\# ;68-

` 29T%54,-

*%7 2%3%: 7#&/.&48-+# !..6(


8/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? c'D":%<

` SELECT EMPLOYEE FROM "_SYS_BIC"."abani/CV_SALES";

` SELECT EMPLOYEE, SUM(SALES) FROM(SELECT * FROM "_SYS_BIC"."abani/CV_SALES")

GROUP BY EMPLOYEE;

` SELECT Table_1.EMPLOYEE, SUM(Table_1.SALES) FROM"_SYS_BIC"."abani/CV_SALES" as Table_1 INNER JOIN

"_SYS_BIC"."abani/AT_DATE" as Table_2

ON Table_1.DATE_SQL = Table_2.DATE_SQL

WHERE Table_2.DATE = TO_CHAR('20150101','YYYY-MM-DD');

%-86E(,( ./ *CD X0#&E


9/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? d'D":%<

` SELECT TOP 50 DISTINCT EMPLOYEE FROM "_SYS_BIC"."abani/CV_SALES";

` SELECT EMPLOYEE, SUM(SALES) FROM(SELECT * FROM "_SYS_BIC"."abani/CV_SALES")

GROUP BY EMPLOYEE;

` SELECT Table_1.EMPLOYEE, SUM(Table_1.SALES) FROM"_SYS_BIC"."abani/CV_SALES _FINAL" as Table_1

WHERE Table_1.DATE_NEW = '20150101'

GROUP BY Table_1.EMPLOYEE;

%-86E(,( ./ *CD X0#&E


10/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 35'D":%<

` Y,#> ;&.;#&',#(` F#=,#> '"# ].,-(` H86+068'#5 +.604-(` *+&,;'#5 =,#>(` H8&5,-86,'E ./ 58'8(#'` ^

Y,(086 >86Z'"&.01" ./ 4.5#6


11/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 33'D":%<

! EXPLAIN PLAN FORSELECT "MANAGER", SUM ("AMOUNT_SOLD")

FROM "_SYS_BIC"."abani.efashion/AN_SALES" WHERE MANAGER = 'Larry‘

GROUP BY "MANAGER";

! 2%3% %+85#4E: G(,-1 N[;68,- 768-(: A((>BeffGGG?)0D(D";??B#>?A;:>iA#$#0$;fA;:>C#(#f;$f45fCd;


12/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 34'D":%<

*H3: Y,(086,\# 768- ) !,4#6,-#! A((>effA;:>?B#>?A;:>iA#$#>: #(908=f A;:>C#(#f;$f


13/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3K'D":%<

! 2.> '. 0(# 29T%54,- '. 8-86E\# ;#&/.&48-+# '&8+#( ,- *%7 2%3%A((>effB?


14/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3j'D":%<

` G(# 6#/' .0'#& ].,-(

` *;#+,/E +8&5,-86,'E ,- ].,-( I-:O .& O:OM

` *#' .;',4,\# ].,- _ '&0# I*7K`M

` G(# '8a6# /0-+',.-( ,-('#85 ./ (+&,;'#5 +86+068',.-=,#>( I*7K`MU

` N[#+0'# ,- *CDV#-1,-#b I2%3% 6,=#M

7#&/.&48-+# !0-,-1 ,- cK4,-(


15/41

9##; 9,=#: '"# (+,#-+#


16/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3a'D":%<

` .0 09 ; 09


17/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3b'D":%<

` .0 09 ; 09


18/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3c'D":%<

f,6'#&(

` O;CD0BB%":;? SB; C;B%@$ (%=; 9%:(;8B #( (A; :0G;B( :;2;:?

` Q$>D( '#8#=;(;8e ':##8( 09 (A; =0C;:B?" /#$ "; DB;C %$ /#:


19/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 3d'D":%<

9#86,-1 >,'" ",1" +8&5,-86,'E

` X0%$B #8; (A; =0B( ;I>;$B%2; 0>;8#(%0$? /0$B%C;8 >DBA%$@ =0B( 09 (A; F0%$B l#( :;#B( 0$ (A; (#":;BG%(A A%@A


20/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 45'D":%<

!E;# ./ +86+068',.-

` pT%B(%$0$;$(%#::) A%@A ;B>? G%(A A%@A


21/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 43'D":%<

g.,- ;&0-,-1

` ,>;


22/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 44'D":%<

A.5#6 ;&0-,-1

` /0$B%C;8 DB%$@ /0$B(#$( P#>>%$@ %$ S.QN.B 908 ;99%8D$%$@?


23/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4K'D":%<

G(# ./ 9T #-1,-#(

` 1I;


24/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4j'D":%<

9#1# ./ ;8&866#6,\8',.-

` /0$B%C;8 DB%$@ S.QN. %$ >:#


25/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 46'D":%<

F#50+# -#'>.&Z 58'8 '&8-(/#&

` E0 8;CDDBA (A; F0%$B (0 ;#:%>:)%$@ =D:(%J:;2;: >#8(%(%0$%$@ G%(A A#BAJ>#8(%(%0$%$@ l0$ B%$@:; 9%;:Cm %$ (A; 9%8B( :;2;:? EA%BG%:: ;$BD8;+


26/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4a'D":%<

H8+",-1

` Q$(80CD(%0$ (0 %=>802;


27/41

9##; 9,=#: '"# 8&'


28/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4c'D":%<

A.5#6,-1 8;;&.8+": /.66.> '"# 4#8(0(

` /0$B%C;8 "D%:C%$@ =0C;:B G%(A # B(#8JB;8908=#$


29/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? 4d'D":%<

A.5#6,-1 8;;&.8+": /.66.> '"# 4#8(0(

V;908; !9(;8


30/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? K5'D":%<

T0,65,-1 ,' &,1"': '"# /,&(' ',4#

` P02; VDB%$;BB L0@%< %$(0 -!.!

` ';8908=#$#8#(; # #$ ;); 09 (A;kD;8) >;8908=#$8D$;C GA;$ $0( kD;8%;C #$C GA;8; DBA;C C0G$ (0 (A; (#":;J:;2;:? /A;


31/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? K3'D":%<

!&8-(/.&48',.-

` T;@8;; 09 (8#$B908=#(%0$ 08 =#(;8%#:%\#(%0$` P#B(;8 C#(# lC%=;$B%0$m

" 8;:%9) =0C;:B l9%;:CB DB;C %$ F0%$B 08 9%:(;8Bm lB#=; 08 $;G (#":;m

` E8#$B#:%9) =0C;:B l


32/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? K4'D":%<

*%7 2%3% A.5#6,-1 "#86'" +"#+Z

P%$%=%\; C#(# (8#$B9;8 ";(G;;$ !$#:)(%(B+


33/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? KK'D":%<

2%3% *7OO 8-5 a#E.-5

` 7&,48&E 0(# ./ +86+068',.- =,#>(: Q$ 9D(D8; 8;:;#B;B

l,'33 #$C ";)0$Cm+ -!.! 0>(%=%\;8 G%:: B;:;>80>8%#(; ;$@%$;B CD8%$@ kD;8) ;I;>08( #$#:)(%< ] #((8%"D(; 2%;GB?

!:B0 # =%@8#(%0$ (00: =#) "; #2#%:#":; (0


34/41

H0('.4#& ?.&Z(".;


35/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? K6'D":%<

T#=#&81# A8].&

` *'8'(" ";908;e 6=%$B+ #9(;8e KB;<

` H"8-1#( I*7KRM" P02; "DB%$;BB :0@%< (0 -!.! :#);8

" 199%:; $0C;B?

" /0$B(#$( =#>>%$@ %$ D$%0$B


36/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? Ka'D":%<

7#-(,.- 768- A8-81#4#-'

` *'8'(" ";908;e K5B;


37/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? Kb'D":%<

S&.+#&E F#'8,6#&

` *'8'(" ";908;e 3dB;:;=;$( B(#8JB:; $0C;B?

V;908; !9(;8


38/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? Kc'D":%<

%05,' f,&4

` *'8'(` M%8= ,(#(B

" ";908;e 3d=%$+ #9(;8e cB;< l3 DB;8m

` P) ,(#(B" ";908;e 3bB;


39/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? Kd'D":%<

C0#(',.-( ) %-(>#&(

76#8(# /.66.> '"# a6.1 ;.(' /.& C0#(',.-( ) %-(>#&(

A((>BeffB?


40/41

7 4536 ,!' ,1 08 #$ ,!' #99%: %#(; #$)? !:: 8%@A(B 8;B;82;C?

!"8-Z E.0/0$(#


41/41

7 4536 ,!' ,1 08 #$ ,!' #99%:%#(; #$)? !:: 8%@A(B 8;B;82;C? j3'D":%<

k dKOJ *%7 *N .& 8- *%7 8//,6,8'# +.4;8-EU %66 &,1"'( (#&=#5U

.0 >#8( 09 (A%B >D":%?I908 #CC%(%0$#: (8#C;=#8* %$908=#(%0$ #$C $0(%80CD8%;(#8) B09(G#8; 0$;$(B 09 0(A;8 B09(G#8; 2;$C08B?

.#(%0$#: >80CD;0BB%":; 9D(D8;C;2;:0>=;$(B+ > 80CD :#(908= C%8;0$ %$ =#*%$@ >D8

Date post:	07-Jul-2018
Category:	Documents
Upload:	anindya-bose
View:	216 times
Download:	0 times

Plan Viz.pdf

Documents