Mqt
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 703 articles for 0.309 sec
Hello, I'm looking for some help with using MQTs created with ENABLE QUERY OPTIMIZATION in DB2 v8 for z/OS. The MQT I'm testing has basically a join of two tables a SUM() field. After refresh, I've decided to enable query optimization and test the AQR features of DB2. So I'd chosen exactly the same query of the MQT's DDL to test. Before running the actual query, I EXPLAIN'ed it     

Group: ibm.software.db2.mvs · Group Profile · Search for Mqt in ibm.software.db2.mvs
Author: saravanainfo
Date: Jul 21, 2008 10:17

Hi. We're currently testing some MQT's around here. I would like to know if is possible to refresh a MQT by loading (using the LOAD utility) data into the source tables. For example, consider this generic MQT: CREATE TABLE MY_MQT (average,sum,max) as ( SELECT avg(table1.field1) as average, sum(table2.field2) as sum, max(table3.field3) as max FROM TABLE1, TABLE2, TABLE3 )
Show full article (0.30Kb) · Show article thread
Jiří Mareš wrote: > Hi, > > at the moment we are using DB2 V8.2 and we are planning the move to V9.1 ... > > but from looking to the web site http://www-306.ibm.com/software/data/db2/9/editions.html it looks like MDC > (Multi-dimensional Data Clustering) and MQT (Materialized Query Table) features has been moved to enterprice editions :-(( > They are still available in Express and WSE     

Group: ibm.software.db2.mvs · Group Profile · Search for Mqt in ibm.software.db2.mvs
Author: listasmalditas
Date: Apr 24, 2008 15:09

M*]JJ5.;5%%6JR%%:G*J48J,Y2]IRE*48\8I3WX\G)2K2NHI7N-A8-GJ1[778N3 M[&KSIS5D.JR,K/8A5*5<90ENE&3=\>6R;3ELTXIQNH``````%%->K;5:-.[+: MABWPME9J>5CXE+@DU&:L5S<MWX7&F2\;^6O]+5RE->K:FBWLMJ$[_=]RG*QY MT\,=6+G[BB^4G&7MKC*7R3AN]H\ODXR"=]I_V6=&_P`%%PO\``@2HC7;+)OS. 5F76WY-^DXEEMMLW*=DY4P;E)ORVVVVV24`````````````````````` M````````$5[L?LLZR_@N;_@3)417NQ^RSK+^"YO^!,"O_2'C^SV:QK/<Y^_F MWV;?1^SP\J.W/9>]^KO
Show full article (1.89Kb)
M)<>+W:CY;6WA-WT``````#/>OY$,[UF]-0FK<26!I,ZXO(KDEEMU9$OP6DTT ME:]W+BMZK%%ONDGH0S!FQX^N/`?LXU?*EOE3;SE9_D$URL7)\)>-N.T?C&,MO MERD&GP````````````````````````````````"E>^7>FSH?5<+IWI3!QM9Z MFRME*AN<_II2E#VXRK@MYRL3EM%%237Q>S4EN%%U`XO1=NOW]+Z?;U?1@XVNV0 M<\JG";=5;<FXQ3;?E1XI[-KEOLVMCG]S^L:^@NC<WJ&_3LG4*L;:+KHG".TI M/C!R<FMHN;C%%N*DURWXM)[!*@1_H7J_1^N.F\?6^G\CWL2WXSA+9646)+E79 M'^S);KQ]FFFFTTW(`     

Group: ibm.software.db2.mvs · Group Profile · Search for Mqt in ibm.software.db2.mvs
Author: samyperia
Date: Sep 13, 2007 07:00

MV\Z4ZPS\?-ZDT3&S\NBFS'KMFY1DJYIII\6M]MVXM[N#;E'9^25`"NM-[)]N M=.Q<W'Q^E,&=>7#V['D2LOG%%;-?ASLE*5;^3\P<7]GOX6WUXG:+M_BZ93@5= M(Z1*BF<;(RMH5EK:GS7*V6\Y+?PTY-./Q:X^"=`"(9?;'H7*Q;L>WH[I^-=T M)5R=6GU5S2:V?&<8J47^YIIK[IG/EV:[>2IR*GTGIO&^ZS(FU%%J2E9!PDHRW MWC%%*3<81:C%%[2BE))J?@"%%3[4]!3][?I#1/Q;H9$ML2"VE#ALH[+XQ^$=X+: M,MY;I\I;L/M3T%%B776U=(:)*5OZRMQ(6Q7SG/XQDFH^;)+PEX48_JPBE-0!! M<'M%%V_PL7#QZ>D
Show full article (0.30Kb) · Show article thread
M[M<JY2]J$?&[Y.-B\)\9-['0R]&]0:RKG5U+TLZ\R<H155:X8"WYJ4>5/)KX M^VM_<?XF[7]N-]`#/>7TYZB:,6ZVKK3I_)LKA*<::J:E.QI;J,7+&4=W]ENT MOWM#+Z<]1-&+=;5UIT_DV5PE.--5-2G8TMU&+EC*.[^RW:7[VC0@`H#^2_J& M_OWTW_ZXA_Y4\J>G/4399?&?6G3]4:YJ$9SIJVM7&+Y1VQF]MVX_))[Q?C;9 MO0@`H#^2_J&_OWTW_P"N(?\`E1_)?U#?W[Z;_P#7$/\`RI?X`H#^2_J&_OWT MW_ZXA_Y4\L3ISU$WXM-MO6G3^-99",Y4VTU.=;:W<9..,X[K[/9M?N;-"`"A M<;ISU!TV.5G6G2U\7"<.%%E*23E%%I2^     

Group: ibm.software.db2.mvs · Group Profile · Search for Mqt in ibm.software.db2.mvs
Author: listasmalditas
Date: Sep 12, 2007 15:13

Show full article (0.83Kb)
    

Group: ibm.software.db2.udb · Group Profile · Search for Mqt in ibm.software.db2.udb
Author: Ian
Date: Aug 21, 2006 11:50

Show full article (0.51Kb) · Show article thread
    

Group: ibm.software.db2.udb · Group Profile · Search for Mqt in ibm.software.db2.udb
Author: Jiří Mareš
Date: Aug 16, 2006 00:38

Show full article (0.34Kb)
    

Group: rec.aviation.piloting · Group Profile · Search for Mqt in rec.aviation.piloting
Author: Bertie the Bunyip
Date: Sep 22, 2008 04:32

Show full article (31.08Kb) · Show article thread
    

Group: rec.aviation.piloting · Group Profile · Search for Mqt in rec.aviation.piloting
Author: Bertie the Bunyip
Date: Sep 22, 2008 04:31

Show full article (31.12Kb) · Show article thread
    

Group: rec.aviation.piloting · Group Profile · Search for Mqt in rec.aviation.piloting
Author: Bertie the Bunyip
Date: Sep 22, 2008 04:30

Show full article (31.10Kb) · Show article thread
    

Group: rec.aviation.piloting · Group Profile · Search for Mqt in rec.aviation.piloting
Author: Bertie the Bunyip
Date: Sep 22, 2008 04:28

Show full article (31.05Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next