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