Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up
for free
SQL Antipatterns Night LT Phantom File
Toshiaki Koshiba
April 11, 2015
Technology
1
1.6k
SQL Antipatterns Night LT Phantom File
http://connpass.com/event/12430/
SQLアンチパターンNight
Lightning Talks
Toshiaki Koshiba
April 11, 2015
Tweet
Share
More Decks by Toshiaki Koshiba
See All by Toshiaki Koshiba
bash0c7
2
61
bash0c7
0
210
bash0c7
0
120
bash0c7
2
400
bash0c7
5
850
bash0c7
2
1.5k
bash0c7
0
130
bash0c7
0
230
bash0c7
0
150
Other Decks in Technology
See All in Technology
line_developers
PRO
2
190
shwars
0
110
oracle4engineer
0
120
miyamotok
0
100
picardparis
4
2.5k
ainehanta
0
110
ks91
PRO
0
350
nnstt1
2
120
you
0
130
jozono
6
1.3k
harshbothra
0
240
recruitengineers
0
250
Featured
See All Featured
pauljervisheath
195
15k
chrislema
231
16k
destraynor
222
47k
searls
204
37k
geeforr
333
29k
cherdarchuk
73
270k
bkeepers
PRO
322
53k
jmmastey
11
710
dougneiner
56
5.4k
sstephenson
146
12k
mthomps
38
2.4k
myddelton
109
11k
Transcript
ڏʑ࣮ʑͷ ϑΝϯτϜ ϑΝΠϧ 42-Ξϯνύλʔϯ/JHIU !CBTI$
lݹ͖ྑ͖͔࣌Βདྷ·ͨ͠ ਅ໘ͳ4&ɺਅ໘ʹ4&z w !CBTI$ w ͜͠ͱ͖͋͠ IUUQSFDSVJUQJYJWOFUNFNCFSUPTIJBLJ
IUUQCBTIDIBUFOBCMPHDPNFOUSZ IUUQTTQFBLFSEFDLDPNCBTIDSVCZBETZTUFN
ઓ૪ͷՐछ ϑΝϯτϜϑΝΠϧΞϯνύλʔϯ
ऴଉ એݴ
ϝσΟΞϑΝΠϧΛʜ w%#ʹ֨ೲ͖͢߹ w%#͔Β֎͖ͩ͢͠߹
ϑΝΠϧͷѻ͍͕Ͳ͏ ͱ͔42-͕Ͳ͏ͱ͔
BWBJMBCJMJUZ γεςϜՄ༻ੑ
lγεςϜz
IUUQTLPUPCBOLKQXPSE&#&#&&"
IUUQTLPUPCBOLKQXPSE &#&#&&" lݸʑͷཁૉ͕༗ػతʹΈ߹Θ͞Εͨɼ·ͱ ·ΓΛͭશମɻମܥɻܥɻz
%#αʔόͱ "1αʔόɻ Մ༻ੑͷʮཁʯʁ
%#αʔόͱ "1αʔόɻ Մ༻ੑͷʮཁʯʁ
ϝσΟΞΦϦδϯͱ "1αʔόɻ Մ༻ੑͷʮཁʯʁ
Մ༻ੑͷʮཁʯ w%#ɹ"1 w%#ɹϝσΟΞΦϦδϯ
Մ༻ੑͷʮཁʯ w%#ʼ"1 w%#ʽϝσΟΞΦϦδϯ
ͭ·Γ w %#αʔόՄ༻ੑͷཁ͔ͩΒ େࣄͳϝσΟΞϑΝΠϧΛ༬͚ΒΕΔ w Մ༻ੑ͕ඞཁेʹߴ͍ϝσΟΞΦϦδϯʹ େࣄͳϝσΟΞϑΝΠϧΛ༬͚ΒΕΔ
݁ w "NB[PO4ͷࢀরΛ֨ೲ˕ w ࣗલϝσΟΞΦϦδϯͷࢀরΛ֨ೲ˕ w %#ͷதʹϝσΟΞΛ֨ೲ˓ʢਏ͋͞Δʣ w "1αʔόͷϝσΟΞͷࢀরΛ֨ೲ⽂⽂⽂
ʮ"1αʔόʯ
"1˰ৼΔ͍
ೖྗ ॲཧ ग़ྗ
σʔλ
اۀ׆ಈͷࠜװ
σʔλ͕ͦ͜த৺
σʔλࢦΞʔΩςΫνϟ
σʔλࢦΞϓϩʔν
%0"
ख๏ͷͰͳ͍
Ձ
%0"
ʘ%ɾ0ɾ"ʂʗ
ʘ%ɾ0ɾ"ʂʂʗ
ʘ%ɾ0ɾ"ʂʂʂʗ
ʘ%ɾ0ɾ"ʂʂʂʂʗ