管理画面とユーザー機能の調和を取り戻す！~クエリパフォーマンス改善の成功物語~ / Restore harmony between administrative and user functions!

Transcript

1. ؅ཧը໘ͱϢʔβʔػೳͷௐ࿨ΛऔΓ໭͢ʂ dΫΤϦύϑΥʔϚϯεվળͷ੒ޭ෺ޠd  
2.  💯
3. 
4.  %#ͷ$16࢖༻཰😇
5.  ো֐͸ಥવ΍ͬͯ͘Δ ຊ൪؀ڥʹͯΞϓϦ޲͚ͷ"1*΍ܾࡁ༻"1*ͷ
   ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢Δো֐Λ֬ೝ
   ௐࠪͷ݁Ռɺ؅ཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕
   %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ
6.  ো֐͸ಥવ΍ͬͯ͘Δ ͋ͳͨͳΒͲ͏ରԠ͠·͔͢ʁ😇
7.  4NBSU#BOL
   *OD
   
   $3&
   αʔόʔαΠυΤϯδχΞ େߴ
   ޫؾ ͓͓͔ͨ͜͏͖ !PI@NJOJTFSB !NJOJTFSB τϐοΫ
   w ࠓ೥ͷ݄͔Β4NBSU#BOL
   +PJO
   w ৽ଔҰࣾ໨͸ཧֶྍ๏࢜ɺΤϯδχΞྺ೥൒
   w ਓੜॳొஃͰzۓுzʜ
8. X
9.  ো֐͸ಥવ΍ͬͯ͘Δ
10.  ো֐͸ಥવ΍ͬͯ͘Δ
11.  ো֐͸ಥવ΍ͬͯ͘Δ ຊ൪؀ڥʹͯΞϓϦ޲͚ͷ"1*΍ܾࡁ༻"1*ͷ
    ύϑΥʔϚϯε͕Ұ࣌తʹѱԽ͢Δো֐Λ֬ೝ
    ௐࠪͷ݁Ռɺ؅ཧը໘͔Βൃߦ͞ΕΔΫΤϦ͕
    %#ͷ$16Λѹഭ͍ͯͨ͜͠ͱ͕ݪҼ
12.  ো֐͸ಥવ΍ͬͯ͘Δ ݪҼ # " 😇 😇 😇 😇 😇 ؅ཧը໘
    
13.  ղܾํ਑
14. ʢ؅ཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢  ղܾํ਑ ूܭ
15.  ղܾํ਑ શͯ௚͢ͷແཧͦ͏ʜ
16.  ղܾํ਑ ୹ظؒͰ΍ΒͶ͹ʜ
17.  ղܾํ਑ w ϘτϧωοΫͱͳΔ"1*ʹߜΓमਖ਼
    w ؅ཧը໘ಛ༗ͷεΩϟϯྔͷଟ͍ΫΤϦΛશͯ௚͖͠Εͳ͍
    w ୹ظؒͰো֐Λ༧๷͢Δ
    w ଞλεΫͱͷ݉Ͷ߹͍
18.  ղܾํ਑ w ϘτϧωοΫͱͳΔ"1*ͷվम
    w NBY@FYFDVUJPO@UJNFͷઃఆʢຊ೔ͷϝΠϯʣ
19.  ղܾํ਑ w .Z42-ͷγεςϜม਺ͷҰͭ
    w 4&-&$5ͷ࣮ߦλΠϜΞ΢τΛઃఆͰ͖ΔʢϛϦඵʣ NBY@FYFDVUJPO@UJNFͱ͸
20.  ղܾํ਑  ᮢ஋ʢNBY@FYFDVUJPO@UJNFʹઃఆ͢Δ஋ʣͱ
    मਖ਼"1*ΛܾΊΔ
     "1*ͷमਖ਼
     ؅ཧը໘ʹͷΈNBY@FYFDVUJPO@UJNFΛઃఆ͢Δ
21.  ᮢ஋ͱमਖ਼"1*ΛܾΊΔ
22. ʢ؅ཧը໘ʣݱঢ়ͷ"1*ͱΫΤϦͷ࣌ؒΛચ͍ग़͢  ᮢ஋ͱमਖ਼"1*ΛܾΊΔ ूܭ
23.  ᮢ஋ͱमਖ਼"1*ΛܾΊΔ w HNP@BP[PSB@WJSUVBM@BDDPVOU TJOEFY·Ͱ͕ݱ࣮తͳमਖ਼Մ ೳͳ"1*਺ʢຊʣ
    w NBY@FYFDVUJPO@UJNF͸ඵ
24.  NBY@FYFDVUJPO@UJNFͷઃఆ
25. 3BJMTͰͷઃఆ  NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ
26. 3BJMTͰͷઃఆ  NBY@FYFDVUJPO@UJNFͷઃఆ ؅ཧը໘ͷΫΤϦͷΈద༻͍ͨ͠
27.  NBY@FYFDVUJPO@UJNFͷઃఆ # " ؅ཧը໘͚ͩʹઃఆ͍ͨ͠
28. 3BJMTͰͷઃఆ  NBY@FYFDVUJPO@UJNFͷઃఆ DPSFBQJ
29.  NBY@FYFDVUJPO@UJNFͷઃఆ w ·͹Βʹઃఆ͞Ε͍ͯΔ
    w Ϣʔβʔ޲͚ΞϓϦʹ΋ NBY@FYFDVUJPO@UJNF͕ ઃఆ͞Ε͍ͯΔ ݕূ؀ڥͰͷಈ࡞֬ೝ 👍 # " 👍 👎
30.  NBY@FYFDVUJPO@UJNFͷઃఆ ͳΜͰ🥺
31.  NBY@FYFDVUJPO@UJNFͷઃఆ 3%4
    1SPYZͷઃఆݟ௚͠
32.  NBY@FYFDVUJPO@UJNFͷઃఆ 3%4
    1SPYZͷઃఆݟ௚͠ # " ઃఆ༗ ίωΫγϣϯϓʔϧ ઃఆແ ઃఆ༗ #FGPSF ؅ཧը໘
    
33.  NBY@FYFDVUJPO@UJNFͷઃఆ 3%4
    1SPYZͷઃఆݟ௚͠ # " ίωΫγϣϯϓʔϧ ઃఆແ ઃఆແ ઃఆແ "GUFS ؅ཧը໘
    
34.  NBY@FYFDVUJPO@UJNFͷઃఆ w ظ଴௨Γ؅ཧը໘ͷΈʹ ઃఆ͞ΕΔ ݕূ؀ڥͰͷಈ࡞֬ೝ 👍 # " 👍 👍
35.  NBY@FYFDVUJPO@UJNFͷઃఆ ΍ͬͨͥʂ
36.  ຊ൪؀ڥʹ൓ө
37.  ຊ൪؀ڥʹ൓ө ຊ൪؀ڥʹ΋ಉ༷ͷઃఆΛ൓ө
    ΫΤϦ࣮ߦ࣌ؒͷ্ݶ͕NT ͱͳΓ༧๷ઢΛுΕͨ ूܭ
38.  ຊ൪؀ڥʹ൓ө ΍ͬͨͥʂʂʂʂʂ
39.  ຊ൪؀ڥʹ൓ө w DPOWFOJFODF@TUPSFTJOEFYͳ Ͳ͸كʹॲཧ͕தஅ͞ΕΔ
    w ୹ظؒʹΫΤϦΛԿճ΋ൃߦ͞ ΕΕ͹$16ʹෛՙ͕͔͔Δ ूܭ ࢒՝୊
40.  ຊ൪؀ڥʹ൓ө Զͨͪͷઓ͍͸ଓ͘ʜ
41.  ·ͱΊ
42.  ·ͱΊ w NBY@FYFDVUJPO@UJNFͰ୹ظؒͰো֐༧๷Ͱ͖Δ
    w ෳ਺ͷ&$4λεΫؒͰ3%4
    1SPYZΛ࢖༻͍ͯ͠Δ࣌͸ .Z42-ͷγεςϜม਺͕ڞ༗͞Εͯ͠·͏͜ͱ͕͋Δ
43. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ