I've zipped the results of EXPLAIN INSERT INTO "tblSummary" SELECT *
FROM "qrySummary"; for my case. It's a zip file that I've renamed to
.txt in order to get around the attachment being blocked by certain mail
servers.
PK yÖ4¨yï ý explain.txtí]]oÇÕ¾/[EMAIL
PROTECTED]( É`ç{ÖHHvÓº¯å: ½)i#H
¢Ú¸ýíïìý%»3+>Ö¤¨3g¾Îó3?üø§½{òî÷¿ûózu{ruµÎ®æl6ûâbu·ù`BQ¦Ï#LgëÕî¾¥Íþ³¸Ü|ú$äËßÿn6ûú»Ùì|µÞx¤Hßoßÿ¿ìóËÙ_×ßÿpmÞϯ²»èÅÙüâÓb½yýâ+ûÍ÷ëÅrójuû¹xûöþçëÅz±ùùúÕêzµÎ?Q<俪_<¿¿½½^dÅëæ¹|ë«eñ
ùÏò¥â»áÃïæ7Yùçÿ¾È®/õKð³ó7onV˳l~w¿În²å¦%aþnñZÝê\sß}½Í~ÙÌþºZ,:L¸dR"ôëP|ß«Õòòåì«{ÝFcµfßÎ^,ËîËÖ÷<$E
7²%°®l8¥ÖwöHX*»#`ýªç»#.K)HjI©¤çNYó1Ò´|©÷»rYϲõUæ3AL9)[EMAIL
PROTECTED]'[EMAIL PROTECTED]@X¸tùGÑ _J¤©´ÐcBA´õÚ[ËöB;ׯAõÎ&óa&S)
CÙêb¿Ôk¢O½Ð$(aZ½0ªônGlõ
µ³É*Чj"
zsÖ~R=¢ªNö$`â
ô©'i{Næ{<NK1RÜV;ße}õáY(ÐÓ©÷J"AJ
V¹6°ÝlúixFÝ èé
2©²\UÊ9Q§ÎØï"dãÙu
§c$Wèí#¤%OrÓôËgÚ=Nâ¥Do&z)ã³$EÜaÃ-e6uWz:ê#åH¸¦*ÑörØ\äÐËc·èõgáDnçî,Lx¤ÃpÀ»ýc¶`ŨRúà.tçÑTïl©ÃêÆÃlg>[EMAIL
PROTECTED]'å^&Ý7r ¬ÔêÄ].Ú4Uk¤4Gþ¯`¡kýäö6[^Ö¾7EU¹ú&ú9Cé`ûº8e"aÖ!rj3 ÝÐh"T"*ë¦$,ì¶ êÉaµÅ´8ßÜ^[«ç#íä
24·lä=û.»Ûd³·«ÕmÕÁ
'[EMAIL PROTECTED] j¡®¦J?B3÷åm>
«u®²Åüzñ߬Ýúß²óL¿
y ÜVçÕ³ªÝsyCÃn¢c# ©^Û£
j7#Ï.k¨ÚAIîÉ+ÛAe*âÜ|\×^ð
¯gªe±Øúà^U¬Nl¯0!føAL?wQáÎ`Jb¥
+ÏúQ¢Ô$
ö±¼I ÏâØY¼¦ñ#籯éñs"¸ZÂé!xmÖ®3ϼgÅ©s¬õ]è<²¢
òMf¹ÍWû¥þæ;Á´Â³Õù*J
¹~®
¬Ýíß|=¿ÉtÏä<m{HMÈ,è-ðûŵnAáÙoµçÅ/_n²ß6zýñÕ³ó?ÂìÓÅæf~;ûK¦ÿ±ûæ§ùõ}£sê
Ô¶2
rBSøéCvñ)[EMAIL PROTECTED]'ÒÕvkvZ¦ô! ¥ùá wR"HÞNðJ¥^<ª) §T5bªª
&duúà´ÞÜ̯ºeóZÀméó,[EMAIL
PROTECTED]@Ã8§Çqu» þD9.NFõN¬n׫Åf~],ÝyªÉzÚɦ]Ý)È1E\ [EMAIL
PROTECTED]"t*m.W+ƨDØ8ÍY²}òch8HBiÈû´q⹿[,¯JÒÌ]Ù88ôôù¢iðQÊíáVÈÇ÷ï\ÚÐ/ç®å¥S/¬&Å?) íccJøÒÞcAÃõQ¯æïçýßeËõ¿ÿÍþøïÕÂôEm¿¿ÊÅ)÷°<Ëäæ7ö°'¯OV½Æûºþ[=Ø;ÏG£^ø<.°óN[n°b¨XC$Þhv%îïìönÞÜöz¸,[EMAIL
PROTECTED]
S²ô¿åj^xË:Ü?mqw¶º¼·ÙA·Ð0ÚméFêÎæëÕËÅ/«õÍbóy,Cɦ¤!8¢%E ÔD|
6§ÑÎäíô?Òë×Ji¼ÑMi¼5>ï¤PþýÏ¿ÞgëÏ0Z"6ú)3@ ÎJh8}0U*®#<[EMAIL
PROTECTED]"z/¾}óÝ,[EMAIL PROTECTED]/¼úç°BÿTòjÔKZåø<±Õá0
&`> c »Òp)Ãqñ »©ð)èÓâbs
ìXzVT'À OçF{Lü°)P
e7OæÉ86Ä!f Ù»Ç)U7âkÀiQU¢
_BÔëuíS¢E9
Ð]<ôäÅÚQ>TcÆ3&Î)ª¥ÉZxt)À³"MºS3U¢(õ?ÍÐå2ΡpïHÊi5ÐÛÍÄb¼yÛ© uR6O+yhlO:N QøHí«ª
cçH94L°¹ §2IÊdÖ"ö0)W6çÔª/k1LjÃ5 "äÓÄÎT <[EMAIL
PROTECTED]//õtë0µÄ»P#6妨VË*0Õu£ÖvåwÔ¾¨ö"U]í%
¡' ñp$¼ºÕ[{ZUu1·&
SÕ%^þÃ.lü|»R±·©ÒòÓéù_VëÅWËÍü:oÅäyc)<NBô
oW'QÌÔ)1s&¸:%-¥¨Kß ¸ø ·Ñ4b*ë[
.;o`Ê,ËW)ò'à¡]qN¢TJ][ S÷O>ºßRyiüúsøiaL%B|i]ú$Îv<3õNªÛ£ã
âëau¬^ÄÎÁx|ar©ÈaÆ®ê^®z÷ï"[EMAIL PROTECTED]/Fr,@èqö<«¢#Ó/4²3£
â"S((2""6"ÈÂ!&>Y,$!CAR½i ÇnáÑÄF ܶ«oæÍ³×WW»õ?ÌëãP
[EMAIL PROTECTED]|¶FZ9æmK¶C³¸iñJ\Ê[!
¯ ÑäJæH0!ÁXÊþ8__e]ªGõb RûTÎJv¤×õ^8¯\¾Aè/Ó¦Y7zÀó*WT¦ÁÖÙ<«ÔÏÇÑÃkyz7½{$
6)§ ©]ËÊb¹ùë4
²´çÀ9jbÒ×?ñ'¢¸¸Ù<^#
© ãðÐV
ï¦WQ5à´çªæPKBÛÆrx-vºRS¦.5Ñ]Öç7Aóu»xj +/[EMAIL
PROTECTED]'`ªh?Ëq*"[EMAIL PROTECTED];ô×ÞÁ
sÚpuº¯É$ p³\ÃláÎd(wyõ±£¬µ$Qjq
?xN&*
[EMAIL PROTECTED]&¬UµÖdZÝÕ-X¨¡lËX£ê£pw7ÈÓëÕÅ¿N^u£9±4
Poy'ëlþjõïl=¿ÊòéqO¶Ö&_V9É!×ñ±-3¨V ¶&b¾Î®7ó?
sZ/Üd^R!Ïéû¨zlÓ."v8ó]W÷ËKxÙ|Ëb_6ßYèÖ&_Ö"uk¥wÓ£\3|c¢!éPqÆ,ÖW¬¯ ØW3g}±¡âöûÉ9J³0]ãxø¢^Å2Dd©XmâáöbE°ki%¥¦"$1K:vV¨I6Áµ`è6Þöhí¦|Ü$Y¾8Qr"Ië
θæñò©\µ"¤]àÛ{U´ ÐÛ¢çHÙ
>zIÞ~ôw¤Ñ4¦ <¾ò¼9©¤µ]ÃG?mé¾=Ì=ÜP*R*Â^<W~ÕS9U´ºê=2JÕö4*ÛuO¶¿)pK
¡ÆAúîÇb¢¿çõ¾fô1Ë)JLB Ï¡ÌÊh·;<wϾ??)³êN}8U'®®uwj3±ÊÕâ «B?nW|[EMAIL
PROTECTED],¢0¥4ÍÞBzËâ£Õ#½ÛÒV"-øÀ*]:$
ÖÛ¨BLâ+Vr¨¹MNù]¯æ61¥z¹KJ©Þ⦢ÔaÛ4AzÍ3ÚÉàzxbÊ
áXUo²
Éôr'Ãv"U*ì8q7¥<OSÂks4Oa-UI/äéóRTƨÄ(-˺ó1:½xx^¬Ð¬^BM¹fG¶j㡼Mb«bT¥RÏRRÜÝK®AÂÓ$ÅGqãã
(®ï.Q ésµÇ[îòÖ
HQªwïò!à¡pN&õvãiÀm«Ä\¸Ã3Ó)ÓÑ8L
Äs¨øY8¦Âq!i;$HQL4Âv¶
¾ùáäû¯?¾§I4QÄF7>å¼[»ÝKl¸}õ¿c¿û¶Ñ±º_/>éß
þØìßóõçÅòêËÙÉ»×}Cãú°ó±'í=Ç<H§([EMAIL
PROTECTED]|>Xc$Oköd7ãqÙÛTÝþ©&Ò{8ôÐ(Ye"aAÇ6{Ü+¡cs¬GK±Â"{.dûGzKi,ÝØOO¦hTEæ±³KÐÖú6ëìïξ·"?·ºÑÖCDܱ]å&µrÙ`ÊYl_ûbËFÚ²
tÏSÊyá*-
KÄ([EMAIL PROTECTED]
1¯6ÄË|}I0w=㤺g,S/üfY Íê!k´ÉdlÍâL¼ñI¦-bÐ3\g{£Ó3É
èF¡]mìàîÚÆøÖ¶Û1|È[óé@>
,ã Î ý:[EMAIL
PROTECTED](3Eâh- ô¶°TÖôª*ë:ÐÛú»D
¸¤) ·qÙÁ5Móy$%÷q¤&<ÉDdÛ7{
²5"§|ìnóYù¬ñví15.FN`çô0/bÊh
I~Û´ñ>¹Ñ=0îû[èàu;;¸Ë\ýÉu¡\X`Oè6¥±ÊOÞcoõî¶ÆelMX<PHÁ¢ñHJ
D~ç
<ïqu4:ÄkxNÎ7ófù«Ö«]Úyý°7WþvGyLVÊx åüK*¡f¤:8Æéìã
¯Ä¢l`± ¡r¼JKT¥Ò8RæúQñG¾Íið©á"¥I«sDÉWã¼JA
Ó,_áav1_!©LGg'DÎEØy Åòänü¼§R
$ Õ`Äú Ѳ83~¦/_^®î¾Îf·ëìbq·X-G?Oõ%Ç¡{øã
Îé ym+
©qÆðnNJïû2HN{¥T½wZ/ùè^ÇXàÃrÂa}N9Õ8 çÀOТÇ
>À9"-çaÍ)òèNTÑ¢ü,Ç¡/{(Ìç¨ÚxN©¾ý¦,
yjfTl©íyR*Ø<²oHU,.¢ë
ÚËDÄÚ @,ik
+d9Ék4 qðÈù
0>Åc¢\¬ÐWÖN3Vøc1{×cI«4
aÇØ°V»yjÁQ ®$`|ma¸k²
æ³úõ±Å×FJZePX±D`X";ÈÍc;[EMAIL PROTECTED]
©^-¶ýÐåX³¼ÐåëÝßé=D¸ÙÝi>1Ѫ¸
)±ýQäP;_ÐäEf³ÎhÃy
àh#TÊ£
¯bC"AÚçÈð©9D¢¤¸¨6¼|É6ìøÖ3(õáÒFÞ£`Údµ§Èh6ïX®*ÆrUA;mx·ÏÐé6Ü! 6b¤Úè#íÄ{
\V $Ú¨
çHjcJÔRÖÎqMt'ZôS0z¤TÏ¢j£oÿiÕÆ´h¬6lÚC¼ÄVÎ5)~ª«©_m¸0¦ÃÚ°é+S
ÈÚpuô)³6B$ÑÚÈ»éXâðM4%¢ÞÚð"[EMAIL PROTECTED]@üµa¨À6¼¹PmølÂSðÔË&<
Mxzdî^ÒÛM¸¼=² ÷ lÂ!à¥CÙ£b[6áéM8lÂ#pLÙ!À»}ÙcâÈ&,
OG6áppN #ðá¿0&¬9vdÙÁàÈ&<² l¸à\lÂ#ðÈ&®>²
lÂ1qdSÄMxPXkíM8$\[ÝM¸wØÓMx0Ä&,7_°Í|ë¼
ù'øÖÁÜT
B,ÎßÛq9f&ÂêóÒËÆâí
ÄÌó*glî]xOU¡ðçÂgÈyø¡qàlxð,·myloGà±5ÈBq3Õ"å¢EÀ6k
èùdÑ0ƺg¦à8aÞ
#DÖÛ»*¯+æV_l:nå»
}åÈ1ð«bgPYc=VTwÀGÃòD("â9MÉÔ·ÄÍUdÇhââ9g¢)q\´±ìèU¬¼WgMÙ
w'WõØ9!òo¬y9:ÃÆc¡Á¡ %cLò`l+*¦kqË2[ÅÞÑGâ£X}(ãdpNI¡$ ,õØe!¢ÊáK
3}²û2Ðæü}]_Z<ójÍ#Ùõ¯Mµx"ðwjDèÀ«Õ{n=ÀL
[EMAIL PROTECTED]
_ÍÑ·Ù/ö¡/(¡ Bµ4ÂO%¥
颺&ÇáÎWnfÃCWíreë?,®>µÄô ÎymÑr¥
[EMAIL PROTECTED])Î77«eÏ¡EéUª5ñCÝÍ¢ìh¦(çSªé
fc+É"ÙÝæÍòÕú&¿N|¹×íc8Ï%¬`ØII `(ë®õ«cMjRTjtj&Á ½®ËrwÊÿ-'§jøêq32UÈpïj«Ë캻R¯$§kp³Ä><д£Ý`bîÅð$U÷c2r÷|!e8í÷óÅõçθ^
@êA\L/{$cÒQ~u=RXáJ/-"[EMAIL PROTECTED]
Ãõ0\3ºäz?Õ'ÏâGÙïJUvû¡]âÎ É|½Y/[EMAIL
PROTECTED]>&¢´¡º¶>&
O8'±1ãHjrºÚ
Þ¶ãÏæËûùu'ÖQûnï¾^\
ÏI©{ôÐg÷äÜÁ$Ekk+Mª(ßÞôð8KºÍ´<'ì,k:ú±ã!×ÿ¤Ê¡½Ó²BÃRöÁy_yîiúÀa~O2Y3VI¬
+F?J¤*S²ÝËzº¶æW±¹fjä ì:/3RHÌ
ätiX²/ ÜÇCeµyÛX&c)[EMAIL
PROTECTED](%xkÀëÌÚ¯±°MêÓO§ç?eëÍâb~½_î\®§æ6 ©×?eÌm
0o©¡· ~Hæ±wtä#'[EMAIL PROTECTED] ´QÓ÷¥
Ï¥îàö1(¦¥Õ6Oz*rngÏØpX1ÖÉQê#-2è!{
à:ÄQäøÃãç«X£+Ä\ËÔµ?M&[EMAIL
PROTECTED]<þÓ+ª\±Xªõk4ªÎ9f»ü¶w%4·ÐyGFÇ!¨è«K¨xl¯¸×ëGäK°ár±VÄØ8!]Q¯f_¼¸¹»ù8¿j1qO^%lö·3çg¾Ù̯¾3ÚAB;ÕæSãýù¬
h[Æôe lÍ>_¬W?.9]h±ùüØÅòSÊ$Ó~N4GÒÞ_m®ì6w;(Ï£W
$;ª 0Ü×(׺+E7½ìä³q¶í` @¾
kn!Ó3r1Ù#ý,ݯ³åÝVÇ~ OÃ1 ðXÖf8)êJ§rrI^ùt÷¯ãZm
Bí Ð+Áz¥¯6èªÒÇÁQ~up.!pî
L*iÝ3é¸ní=wn;QWQHÎXÂw´ì¦â)ÕÓvê+ÀC+sPÇÑöþ8,uÈÙZRhÇ-\ò$çëð"Ûʳ^KiÖ<ÚÁïö·½~ÓcÖ·¾ £ÞÇz ТÇì³³m©Òºµúþü¤¤Ô
}0¤ZÝ
mr&\òA±³+x¸Ò9C»¥Õ_òf?®Vñê«f³¯ÕrX?UÖV1Bn{Ììÿ ÷äâ1Ø'÷_æ¡
ÙCkØÇlX<1,a$P¢
óÉä<w{ëe» Ķßö=Jfi+¯)ò{$
ÿX-]©wÛ~½-M+ó÷4hÛ§;¾ÜL¯¢y"gU¿Åü®¯
K¤óûÛÛë
K&÷÷þ?PK yÖ4¨yï ý
¶ explain.txtPK 9
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster