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.
PKyÖ4¨y‰ïœýexplain.txtí]]oÇÕ¾/[EMAIL 
PROTECTED](šÉ`ç{ÖHHvÓº¯å:– ½)i#•H…¢Ú¸ýíï잝ýš™%’»3+>֚¤¨3g¾Îœóœ3?üø§Ÿ½{òî÷¿ûózu{ruµÎ®æ›l6ûâbu·ù–`BQˆ¦Ï#LgëÕî¾¥œÍþ³¸Ü|ú–$äËßÿn6ûú»Ùì|µÞx›¤ˆHßoŠßÿ¿ìóËً_ןßÿpžmÞϯ²»èÅÙüâÓb™½yýâ+ûÍ÷ëÅrójuû¹xûöþçëÅz±ùùúÕêzµÎ?Q<俪_<¿¿½½^dÅëæ¹|ë«eñ…ùÏò¥â»áÃïæ7Yùçÿ¾È®/õKð³ó7onV˳l~w¿În²å¦%aþnñZÝê\s™ß}š½Í~ÙÌþºZ,:L¸dˆR‡˜"–ôë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˜èí#¤%Or˜Óô˔gÚ=€žN⊥Do&z)㊳$EÜaŒ’Ã-e6žuWz:Œê#åH›¸ˆ¦*Ñö—rØ\äÐ˝c·•èõgáD›nçî,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?w†QáÎ`­›Jb¥
+ž›ÏúQ¢Ôœ$      
­ö€±¼IÏâØY¼¦ñ#­ç±¯éñs‚”„"¸ZÂé!€“ˆx–m֋‹®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¥^<‰ª)§T5‡bªª
&„„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$Þh­v“%î­ïìönÞÜöz¸,[EMAIL
 PROTECTED] 
‘S²ô¿åj^xË:܃?mqw¶º¼·Ù™A·Ð0ŽÚméFêÎæëՏËÅ/«õÍbóy,Cɦ¤!8¢%E™ ÔD|       
6œ§ÑÎäíô˜?Òë•×JŽi¼ÑMi¼5>ï¤PþýÏ¿ÞgëÏ0Z"6ú„)3@       ÎJh8}0‹U*®#<[EMAIL 
PROTECTED]"z/¾œ}óÝ,[EMAIL PROTECTED]/¼ú爰BÿTòjÔKZåø<±Õá0
&`>  ­c»Òšp)Ãqñ »©ð)èÓâbs™…ìXzVT'À„      O€çF{LŠü°)P   
eˆˆœ7Oæ„É86Ä!fÙ»Ç)U7âkÀiQU­¢“
_BÔëuíS¢Ež9
Ð]<ô˜äÅÚQ>Tc’Æ3&Î)—ª¥ÉZxt)À³"MºS3U¢(õ?ÍÐå2Ρpï‹HÊi5М­ÛÍĝb¼yÛ© uR6O+ŸyhlO:‘“N–•QøHí«ª’
 cçH94‡L°¹§2IÊdÖ"ö0)W6çԆ€ª/k1L†jÃ5"­äÓÄÎT <[EMAIL 
PROTECTED]//õtë0µžÄ»P#6妨“VË*0Õu£Ö™våwÔ¾¨ö"U]í%     
¡'ñp$¼ºÕ[{ZUu1·&…SÕ%^þÃ.l‡ü|»R±·©ÒòÓéù_VëÅWËÍü:oÅäyc)<NBô
›oW'QÌÔ)1s&¸:%ž-¥¨K’ß     ¸ø·ƒÑ4b*ë[ 
.­;o`Ê,˓W)ò'à¡]—qN•¢TJ][S÷O>ºßRyiüúsøiaL%B|›i]ú$Îv<­3õNªÛ£ã
âëau¬›^ÄÎÁx|a“r‘©ÈaÆ®ê^®z÷›ï"[EMAIL PROTECTED]/Fr,@èqö<«¢#Ó/4²3£ 
Žâ"S((2""6"ÈÂ!&>Y,$†!CAR½i ‘ÇnáÑÄF        ܶ«€œžoæÍ³×W­W»õ?ÌëãP
[EMAIL PROTECTED]|¶FZ9æmK¶C³¸i˜ñJ\Ê[!
¯’ ÑäJæH0!ÁX‹Êþ8__e]ªGõbRûTÎJv¤˜×õ^8¯\¾Aè/Ó¦‰‡Y7zÀó*W™T¦ÁÖٕ‚<«ÔÏÇÑÃkyz7½{“$—
  6)§‰   —©]˝Êb¹‡ùë4
²´˜çÀ9jbÒ×?ñ'¢¸¸Ù<•^#…©       ãðÐV
鍊W”Q5à´çªæP‘„KBÛƕrx-vºRS¦.5Ñ]Öç7Aóu»xˆjœ+/[EMAIL 
PROTECTED]'`ªh‘“?Ëq*"[EMAIL PROTECTED];ôŸ×ÞÁ“ 
sÚpuº¯É$p³\ÃláÎd(wy•™õ±£¬µ$Qjq
?xN&*
[EMAIL PROTECTED]&¬UµÖdZÝÕ-X¨•¡lËX£êŽ£pŠw7ÈÓëÕÅ¿N^u£9±4    
Poy'ëlþjõïl=¿Êò道qO›¶Ö&_V9É!„×­ñ±-3¨V¶&b¾Î®7ó?
sZ/Üd^R!Ïéû¨zlÓ."v8—ó‹]­W÷ËK›xÙ|Ëb_6ßš‚YèÖ&_Ö"u•Žk¥wÓ£†\3|c¢!éPqÆ,ÖW¬¯ØW3g}±¡âöûÉ9J³0]ã€xø¢^Å2Dd©Xmâáö†bE°€­kŸ’iŠ%“¥¦"$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Ë)JL­BÏ¡ÌÊh·;Š<wϾ??)³‰êN}8U'®®uwj3±ÊÕâ «B?nW|[EMAIL
 PROTECTED],¢0¥4ÍÞBzËâ­£Õ#›½ÛÒV"-†ø€Àˆ*]:‚$       
ÖÛ¨BžLâ+Vr¨¹MNù]¯æ61¥z¹KJ©ÞŽâ¦¢”‚ÔaÛ4A’zÍ3ÚÉàzxbÊ
áXUo²Ž
Éôr'Ãv"U*ì8q7¥Š<O‰SÂks4Oa-UI‡/äéóRTƨÄ(-˺“ó1:½‰xx^†’¬Ð¬^BM¹‡†fG¶j㡼“M’b«bT¥‰RÏRRÜÝK®AÂÓ$ŇGqãã
(®ï.QésµÇ[îòօHQªwïò!à¡pN&õv„ãiÀm«Ä\¸Ãš3Ó)Óѝ8L
Äs¨øYŽ8¦Â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,ÝØOžO¦hTEæ±³KН֎úœ­6›ëìŸïξ·"?­·ºÑŸÖ›CD€Ü±Ÿ†]å&µrÙ`ʘYl_ûbËFÚ²
tŠÏSÊyá*-…KÄ([EMAIL PROTECTED]
1¯6ÄË|}I0w=㤺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í1Ÿ5.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¼JKT¥Ò8RæúQñG†Œ¾‡Íið©á"¥I«sDÉWã¼JA…Ó,_áav‚1_!©LGg'DÎE؆y ‡Åòänü¼†§R
$—     Õ`Ăú Ѳ83~¦/_^®î¾Îf·ëìbq·X-G?šO‘õ%Ç¡{øã 
Îé ym+…©qŒÆðnNJïû2H‘N{¥›Š„TŒ½Ÿ†wZ/—ùè^ÇXàÃrÂa}N9Õ‚8çÀO•Ð¢Ç 
>À9"-ça͍)òèNTÑ¢ˆü,Ǘ¡Ž/€{(Ìç¨ÚxN”©¾ý¦,…yjfTl©íyR*š”Ø<‰²oHU,.¢ë
ڔËDÄÚ @,ik…+d9Ék4qð‹Èù…›0>Åc¢\¬Ð™W֜N3VøŠc1‚{×cI«4  
aÇØš°V»yjÁQ—®$`|“ma¸k²
æ³úõ±Å×FJŽZe­PXƒ±D™`X"ž;ÈÍc;[EMAIL PROTECTED]
©^-›¶ýÐåX³¼ÐåëÝßé=D¸ÙÝi>1ц›ª¸
)±ýŽQäP;_ÐäEf³‘ÎhÃy”…àh#TÊ£
¯bC"AڈçÈð©9D¢¤¸¨“6¼|•É”6ìøÖ3(õáÒFÞ“£`ژdµ§Èhš6ƒïX®*ÆrUA“;mx·ÏÐéž6Ü!‰ 6b¤„Úè#íÄ{
\V$Ú¨
犍HjcJÔR֛έqMt'Z”ôSž0z¤„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áé‘M8ŽlÂ#›pLل!À»}لcâÈ&,    
OG6áppN #›ðá¿0&¬9vdلÁàÈ&<²   l¸à\“ŽlÂ#›ðÈ&®Ž>²   
lÂ1qdžSđMxPXkí‘M8$\[ݑM¸wؖӑMx0ŒÄ&,”7_°Í|ë¼
ù­‡'øÖÁ܏T…B,ÎßÛq9f&†ÂêóÒËÆâí…ÄÌó*glî]x—OU¡ðçÂgÈyƒø¡qàl‡xð,·myloGà±5ÈBq3Õ"å¢EÀ6k
‘èùdÑ0ƺg¦à8aÞ
#D֗ۻ*¯+æV_l:n–å»
›}åÈ1ð«bgPYc=VŽTwÀGÂòD("â9MÉÔ·ÄÍUŠŸdÇhââ9gœŒ¢)q†\´‰±‚ìèU¬¼WgMŒÙ
w'Wõ„Ø9!òo¬y9:ÃÆc¡Á¡   ›%c­Lò`l+*¦‹kqžË2[ÅÞÑGâ£X}(ãdpNI¡˜›$ ,õØe„!¢ÊáK 
3‡}²û2Ðæ‘ü}‘]_Z<ójÍ#Ùõ¯Mµx"ðwjDŒèÀ«Õ{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`(ë®­õ«cMjRTjtj&Á ‡½®ËrwÊÿ-'§‘jøêqž32UÈ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Ì
   ätiŒX²/ÜǙCeµyÛX&c)[EMAIL 
PROTECTED](%xkÀšëÌÚ¯±°MêÓO§ç?eëÍâb~½_î\®Š§æ6  ©×?eœ™Ìm
0o©¡· ~‚Hæ±wt•ä#'[EMAIL PROTECTED]     ´‘QÓ÷¥
ςƒ¥î†àö•1(¦¥Õ6Oz*rngÏØ‹pX™1ÖÉQê#-2ª§è!{
à:ēQäøÃãç«X£+Ä\ˋ“Ôµ‰?M‡&[EMAIL 
PROTECTED]<þӊ+‹ª\±Xªõ‹­k„4ªÎ9f»ü¶Žw%”4·žÐyGFÇ!¨è«K‚¨xl¯¸×ëGäK°ár±VÄØ8!]„’Q¯f_¼¸¹»ù8¿j1qO^™%lö·3çg¾Ù̯¾3ŸÚAB;ÕæSãýù–¬
h[Æôel͉>›_¬W?.9]h±ùü؍ÅòŸSÊ$Ӌ~N4‚GÒÞ_m®†ì6w;(Ï£W
$;ª0”ŸÜ×(•׺+E7›ˆ‰½ìä³q¶í`  @¾
kƒn!Ӈ3r1Ù#“ýˆ,ݯ³åÝVÇ~OÃ1ðXÖf8)êJ™§rrI^ùt÷š¯ãZm
BíÐ+Áz¥¯6èªÒÇÁQ~up.!ƒpî‚ 
L*iÝ3é¸ní=wn;QšWˆQH•ÎXÂw´ì‹¦žâ)ÕÓvê+ÀC+sPÇÑöþ8,uÈÙZRhÇ-\ò$çëð"Ûʳ^ŠKiÖ<ÚÁïö·½~ӊc֎·¾£Þnjz Ð¢Ç쳂³m©Òºµúþü¤¤Ô
}˜0¤ZÝ
mr&\òˆA±³+x¸Ò9C»‚­¥Õ_òf?®V‡ñê«f³¯ÕrX?UÖV1Bšn{Ììÿ÷äâ1‡Ø'÷_æ¡ 
ÙCkžØÇl–X<1,a$P¢
óÉä<›w{ëe»Ä¶ßö“=Jf‡i+‹¯)ò•{›$     
—˜ÿX-]©wÛ~½-M‘+ó÷4—hÛ§;¾ÜL¯¢y"gU¿Åü®¯
‡K¤óûÛÛë…K&÷÷þ?PKyÖ4¨y‰ïœý 
¶explain.txtPK9
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to