 |
 |
Archives of the TeradataForum
Message Posted: Thu, 04 Nov 2004 @ 23:10:22 GMT
| Subj: | | Can anyone throw some light on the difference... |
| |
| From: | | Prabhjot Sodhi |
Hi:
I found this peculiar difference in the explain for same query but difference in number of values in the IN clause of the query.
If I submit the whole lot of values, the explain shows a ALL AMP Retrieve and the query takes ages, but the same query with about 25-30 odd
values does a Single AMP retrieve.
Following is the query and the resp. explains:
No. of rows in the table : 1 billion
Stats collected : 18/10/04
The Tkt_no is a primary Index
Stats are defined for JE_PROD on 18/10/04.
All values query:
-----------------
SELECT
TKT_NUM,
SUBSYS_REF_DTE,
SUM(CASE WHEN DR_GL_ACCT_NUM ='390256' THEN GL_DOL_AMT WHEN
CR_GL_ACCT_NUM = '390256' THEN -GL_DOL_AMT END) V390256
FROM
UserViewDB.UserView1
WHERE
TKT_NUM IN ('0814474462865',
'0814474488228',
'0814474488231',
'0814403717996',
'0816289997210',
'0816289997211',
'0813461748212',
'0813461748213',
'0814403725021',
'0814472044809',
'0814403725022',
'0814474127267',
'0814403868136',
'0814476523876',
'0814477159349',
'0814474303429',
'0814473929033',
'0814473928890',
'0814474226441',
'0813589778981',
'0814474042335',
'0814477221283',
'0814474226511',
'0814474227473',
'0814474297818',
'0814473417359',
'0814474042334',
'0814474303267',
'0814474303266',
'0816213231891',
'0814473932274',
'0814473988819',
'0814473988817',
'0814473988009',
'0813064755971',
'0817218399915',
'0813589421466',
'0819196062273',
'0814474238057',
'0813589597852',
'0817526126350',
'0819198418199',
'0819196036946',
'0819198418153',
'0819198418155',
'0814500058605',
'0814500058749',
'0814473022892',
'0813589728402',
'0814500063536',
'0813590001298',
'0819141150612',
'0814500030057',
'0814473741706',
'0819195957539',
'0819196036637',
'0819198418200',
'0819196036948',
'0819196169991',
'0819197170074',
'0819168125694',
'0813591439452',
'0814403896282',
'0814403896284',
'1340304047632',
'2600704046356',
'0861003042536',
'0810303043300',
'9990703047545',
'0814403896268',
'2600404046407',
'0813330562589',
'9990704042168',
'0810303046002',
'0160403046433',
'2600704046334',
'9990704042166',
'0813589442415',
'2600404046405',
'0010803043351',
'9990704042169',
'2600404046406',
'2170104049610',
'0980903044333',
'0860904041265',
'2600604044420',
'0813589779155',
'1800803041875',
'0810303043302',
'9990703041203',
'0160703041229',
'1930404041220',
'0813589378525',
'0813625703790',
'0813625703791',
'0813330619398',
'0810203041866',
'2600404046408',
'0060704041831',
'2600704042572',
'0550804043014',
'0810303046451',
'6561003043023',
'0813575640082',
'0430903045751',
'1760403046321',
'9990703041205',
'0814500029894',
'2600704042594',
'2180403046442',
'0814500041390',
'6560303041221',
'6290703043415',
'0720803049686',
'0160504047595',
'0810203046342',
'2171103041834',
'0810303043900',
'6560703040989',
'9990803042690',
'0813589296808',
'1251003041821',
'0430903045752',
'0810303045701',
'9990603044249',
'0010403043353',
'1570804040600',
'2600704042555',
'2170104049609',
'2600804041234',
'9320404046000',
'0810303046453',
'0813589688380',
'0813589868188',
'0813330324226',
'0810203040022',
'7380303043307',
'2600704046391',
'2600404040751',
'2600804041231',
'9990603044255',
'7810503049630',
'0160204048369',
'0160204048367',
'9990803042688',
'0813465394561',
'0810303046428',
'6560504041844',
'0810303043938',
'0720404040756',
'9990803042699',
'0570503049616',
'2170104049625',
'1600104049615',
'9990503049606',
'2600204046434',
'9990503049614',
'1250603043067',
'2600704042619',
'0060803041359',
'0814474093134',
'2600604044422',
'2600204046411',
'2600704046354',
'2600704046357',
'0431203040927',
'0830503040926',
'9990803042697',
'0501003045717',
'9990803042696',
'0740504041044',
'0813590355268',
'0813589214923',
'0813589688406',
'0570603041896',
'0140903049664',
'0813331009509',
'2170603040991',
'0010403043328',
'0720104041816',
'0810403043328',
'1801103042633',
'0120603041004',
'6180704049615',
'9990603044257',
'0861103049719',
'2600703040927',
'0431203040932',
'0050704047695',
'2600204046372',
'5550304047661',
'0813626235904',
'0370504041291',
'6560504041304',
'0817218399916',
'2600804041233',
'9990603044246',
'2600404046409',
'2600704042559',
'9990603044240',
'0860703040000',
'0650804040124',
'0860603047252',
'0830404044201',
'6560503040610',
'2600604044421',
'2600704042599',
'0813589296406',
'1310204043068',
'2600704042593',
'0550704041826',
'6560504041845',
'9990603044252',
'9990603044239',
'0810203043456',
'2600704042556',
'0813588788158',
'0813589179108',
'0810203046348',
'2570803049690',
'6560503044028',
'0810203040064',
'0720903041804',
'0120000043935',
'0813679781255',
'0813538049215',
'0860304041334',
'0140303041831',
'0140403041296',
'2600704046339',
'0810203041859',
'2600704042552',
'0810303043018',
'6560703040996',
'1760204040928',
'0370703043318',
'2600604044431',
'2600704046341',
'0010403043351',
'2600704042595',
'0720304040935',
'0010803043355',
'0810203046031',
'6430704040938',
'2600704042574',
'0010403043352',
'9990803042400',
'6560503044029',
'2600603046000',
'0814473879575',
'0430903045753',
'0810303046452',
'0060803041285',
'1251003041818',
'1171003040921',
'2600404046410',
'0810804041247',
'0813082710498',
'0814500065663',
'0814474238461',
'0814500062941',
'0810303046001',
'0819196164394',
'0814500066075',
'9990503049613',
'0814500063984',
'0814500062920',
'0814500062940',
'0814500050998',
'9990703041207',
'0814473112339',
'0814474172339',
'0814500058750',
'0814500061526',
'2600204046400',
'0814500055412',
'0814500060604',
'0814474031976',
'0814500060049',
'0814500063027',
'0814500066136',
'0814500062954',
'0814474297597',
'0814500062981',
'0814500050950',
'0814500029973',
'0814500060051',
'1250503043065',
'0814500056242',
'2600204046423',
'0814500066092',
'0720703041058',
'0814500065667',
'0814500062936',
'0814500063337',
'0814500060608',
'0814500050990',
'1760000043326',
'2600204046422',
'2600704046336',
'0814474120699',
'0814500062969',
'0814500050989',
'0814500060077',
'7380303043306',
'0814500054948',
'0814500060628',
'0814520723027',
'0814500056231',
'0813329873736',
'1250503043066',
'0814500054946',
'0814500070006',
'0814500054802',
'2600604044399',
'0570603041877',
'0140403043133',
'0814500054806',
'0814500060601',
'0814500050991',
'0814500008925',
'0814500060057',
'0814500060590',
'9990503049612',
'0814500066126',
'0814500030036',
'0813870993562',
'0814500062953',
'0814403889381',
'0814500054804',
'0814500064300',
'0814500059602',
'6430404040936',
'2170903047220',
'0814500062976',
'0814500055472',
'0814500025773',
'2440604041323',
'6560703040991',
'6560204044352',
'0814500061537',
'0810203046347',
'0814474121073',
'0814500064234',
'0813329873737',
'0814500062861',
'1800503043923',
'0814500047270',
'0814500062968',
'6180503049600',
'0814500060633',
'0814500066145',
'0814500008914',
'0810203046015',
'0814500029938',
'0814500060056',
'0814500061607',
'0814500066135',
'0814500058914',
'0570303046015',
'0814500059575',
'0814500025804',
'0160703041230',
'0814500058973',
'6560703041013',
'0814500062977',
'0814500060078',
'0814500063981',
'0814474095473',
'0814500060104',
'0814500068702',
'2600204046435',
'0814500054805',
'0861003042537',
'0814500068104',
'0420704041206',
'0814500054949',
'0814500029972',
'0814500063026',
'0861003042535',
'0814500050987',
'0814500063338',
'0430404043062',
'0814500063678',
'2600704042566',
'0814500061188',
'9990503049611',
'0813589733681',
'0814500063544',
'0814500029990',
'0570303046013',
'0814500056202',
'0814500066157',
'0814500064307',
'2600804041230',
'0720404040931',
'0813870886836',
'0813870886839',
'0980404044243',
'2600404046411',
'6560503044025',
'2600604044425',
'6430504042700',
'0160100347504',
'0420704040306',
'0140304047641',
'6770703048239',
'6560104047560',
'2200304045758',
'0141103048296',
'0370703043316',
'2600704042562',
'0550403043163',
'9990703041206',
'9990603044237',
'2600704042558',
'0810203043467',
'0570603041890',
'1251003043111',
'0790504040459',
'0813589442380',
'9990603044258',
'7810503049649',
'2290804040630',
'1620404042568',
'9570904040922',
'2570404045700',
'0810203041853',
'2171103041833',
'0813589267390',
'0813589267388',
'0813589267391',
'0570603041894',
'6560104047522',
'2600404046412',
'0810303043303',
'2600704046340',
'9990704042167',
'0160603041865',
'0010803043352',
'9990603044253',
'9990703041204',
'2600704042597',
'2600704042579',
'2600704042596',
'2170204049616',
'2600704042565',
'9990703041202',
'2600704046363',
'2600204046433',
'0813331656937',
'0813590214008',
'0813589417591',
'0813589417595',
'0813590214009',
'0813589895378',
'0813590190785',
'0816697657657',
'0813589895316',
'0813589668511',
'0813330690379',
'2601103041253',
'0050803040957',
'9990603044238',
'1250503043048',
'0810303046457',
'1760504040631',
'0160703046352',
'0810203040016',
'0010903043424',
'0813589178956',
'0810203040011',
'2600704042582',
'2570503047561',
'0814474095470',
'6180503049601',
'0813589417584',
'2440604041316',
'2600204046410',
'0814474238440',
'0814474095756',
'0814474095471',
'0760303046004',
'6180703046310',
'9990703041201',
'2600704046352',
'6560604040900',
'9990603044251',
'6560104040965',
'0814500018501',
'1760603047566',
'1250403041838',
'0010403043323',
'6770104040971',
'0810203040008',
'2320504049609',
'0810203041869',
'0813633068530',
'7810903042451',
'0813590088172',
'0810203041863',
'0813590046526',
'0813590046695',
'0813589645856',
'0860804046316',
'1260504041052',
'2600704046345',
'0010403043335',
'0120603041006',
'2600603049673',
'2600704046353',
'2600704046361',
'0720604040952',
'0861103042658',
'2571003041068',
'0814403888521',
'2600604044434',
'2600604044427',
'2570803049689',
'0160603041866',
'0740204040951',
'2600604044391',
'0431203040926',
'6770204041841',
'5550403044077',
'0810303045702',
'0810203040053',
'1621003041242',
'2600604044436',
'2600604044433',
'0060404047588',
'2600804041229',
'2320504044514',
'0810203041868',
'0530903040992',
'0810203040015',
'0814473932985',
'0814474212642',
'0810303045700',
'2600704046342',
'0814474238701',
'0813331062734',
'0814474151844',
'0814474280299',
'0814474238412',
'0814474183105',
'0814500024118',
'6560503044027',
'0010803043354',
'0814474183106',
'0816212735080',
'0814473976714',
'0814474013199',
'1250403041837',
'7060403043220',
'2600604044393',
'0813590003255',
'6560504041302',
'2600803040959',
'0120603041008',
'0630404042586',
'7380404044238',
'2600704046355',
'2570704040945',
'0817281355870',
'0817281355865',
'0817281355868',
'0813331342924',
'0814474238413',
'6180503049602',
'7380404040452',
'0814474239282',
'2600604044398',
'1930404041219',
'1340204041809',
'1250403041854',
'1250803047741',
'0813502189356',
'0551003040980',
'0060803041360',
'0813589214965',
'9990703044033',
'1310703044566',
'0830204049623',
'0010803043353',
'0813588763937',
'0815004751146',
'6031003045704',
'2600704046338',
'1250603043068',
'2600704046346',
'0814473912919',
'0430703044034',
'1600303043059',
'2600504044378',
'1250803047740',
'6560503044030',
'0060303046492',
'2600704046362',
'0813692459807',
'1250403043137',
'0819195957535',
'0819196062271',
'0819195957537',
'0819196062270',
'0550903041052',
'0819196169897',
'0819196164397',
'0813591439453',
'0813692459805',
'0819168125692',
'0819196038352',
'0819196062269',
'0813692459806',
'0819168125693',
'0819168125691',
'0813604044586',
'0814500060626',
'0814500065615',
'0814500065617',
'0814500043319',
'0814474095358',
'0814500060076',
'0814500065651',
'0814500056243',
'0814474095359',
'0813604436578',
'0811512465109',
'0813554693473',
'0814474095757',
'0813692459804',
'0814500062894',
'0814500063029',
'0814500063733',
'0814500063947',
'0814500050971',
'0814500063991',
'0813331526478',
'0813589609168',
'0813589140089',
'0813589054906',
'0813589054908',
'0813679425588',
'0813588729104',
'0814500060105',
'0814500050988',
'0814500065515',
'0814500065665',
'0814500062921',
'0814500058604',
'0814500060627',
'0814500062955',
'0814500063038',
'0813589516082',
'0814403888520',
'0816257382864',
'0814500062878',
'0813591990407',
'0817066957532',
'0812431207870',
'0814473971093',
'0813588874693',
'0814473988105',
'0813589441056',
'0813589435055',
'0813589778226',
'0813589179228',
'0813588829693',
'0813064755972',
'2320804042748',
'0813331491445',
'0814474095407',
'0813589659718',
'0813589387335',
'0813589640185',
'0813589387088',
'0814473169579',
'0813589442366',
'0813588964047',
'2351003049641',
'0813589144062',
'2351003040612',
'2351003049656',
'2351003049648',
'2351003049642',
'2351003049661',
'2351003049655',
'0814473678443',
'6560304042512',
'2351003049662',
'2351003049654',
'2351003049653',
'2351003049640',
'2351003040611',
'2351003040613',
'2351003049647',
'2351003049650',
'2351003040627',
'2351003049636',
'2351003049643',
'2351003049645',
'2351003049637',
'2351003049663',
'2351003049649',
'2351003049639',
'2601103041251',
'7380404044504',
'2601103041222',
'2601103041221',
'9640000000000')
AND JE_ACCT_PRD <= '200409'
GROUP BY 1,2
EXPLAIN for the query:
----------------------
Explanation
-------------------------------------------------- | |
| | 1) | First, we lock UserDB.UserTbl1 for access.
| |
| | 2) | Next, we do an all-AMPs SUM step to aggregate from UserDB.UserTbl1 by way of an all-rows scan with a condition of
("((UserDB.UserTbl1.TKT_NUM =
'0814474462865') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474488228') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474488231') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403717996') OR ((UserDB.UserTbl1.TKT_NUM =
'0816289997210') OR ((UserDB.UserTbl1.TKT_NUM =
'0816289997211') OR ((UserDB.UserTbl1.TKT_NUM =
'0813461748212') OR ((UserDB.UserTbl1.TKT_NUM =
'0813461748213') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403725021') OR ((UserDB.UserTbl1.TKT_NUM =
'0814472044809') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403725022') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474127267') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403868136') OR ((UserDB.UserTbl1.TKT_NUM =
'0814476523876') OR ((UserDB.UserTbl1.TKT_NUM =
'0814477159349') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474303429') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473929033') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473928890') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474226441') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589778981') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474042335') OR ((UserDB.UserTbl1.TKT_NUM =
'0814477221283') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474226511') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474227473') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474297818') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473417359') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474042334') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474303267') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474303266') OR ((UserDB.UserTbl1.TKT_NUM =
'0816213231891') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473932274') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473988819') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473988817') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473988009') OR ((UserDB.UserTbl1.TKT_NUM =
'0813064755971') OR ((UserDB.UserTbl1.TKT_NUM =
'0817218399915') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589421466') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196062273') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238057') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589597852') OR ((UserDB.UserTbl1.TKT_NUM =
'0817526126350') OR ((UserDB.UserTbl1.TKT_NUM =
'0819198418199') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196036946') OR ((UserDB.UserTbl1.TKT_NUM =
'0819198418153') OR ((UserDB.UserTbl1.TKT_NUM =
'0819198418155') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058605') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058749') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473022892') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589728402') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063536') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590001298') OR ((UserDB.UserTbl1.TKT_NUM =
'0819141150612') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500030057') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473741706') OR ((UserDB.UserTbl1.TKT_NUM =
'0819195957539') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196036637') OR ((UserDB.UserTbl1.TKT_NUM =
'0819198418200') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196036948') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196169991') OR ((UserDB.UserTbl1.TKT_NUM =
'0819197170074') OR ((UserDB.UserTbl1.TKT_NUM =
'0819168125694') OR ((UserDB.UserTbl1.TKT_NUM =
'0813591439452') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403896282') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403896284') OR ((UserDB.UserTbl1.TKT_NUM =
'1340304047632') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046356') OR ((UserDB.UserTbl1.TKT_NUM =
'0861003042536') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043300') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703047545') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403896268') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046407') OR ((UserDB.UserTbl1.TKT_NUM =
'0813330562589') OR ((UserDB.UserTbl1.TKT_NUM =
'9990704042168') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046002') OR ((UserDB.UserTbl1.TKT_NUM =
'0160403046433') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046334') OR ((UserDB.UserTbl1.TKT_NUM =
'9990704042166') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589442415') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046405') OR ((UserDB.UserTbl1.TKT_NUM =
'0010803043351') OR ((UserDB.UserTbl1.TKT_NUM =
'9990704042169') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046406') OR ((UserDB.UserTbl1.TKT_NUM =
'2170104049610') OR ((UserDB.UserTbl1.TKT_NUM =
'0980903044333') OR ((UserDB.UserTbl1.TKT_NUM =
'0860904041265') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044420') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589779155') OR ((UserDB.UserTbl1.TKT_NUM =
'1800803041875') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043302') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041203') OR ((UserDB.UserTbl1.TKT_NUM =
'0160703041229') OR ((UserDB.UserTbl1.TKT_NUM =
'1930404041220') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589378525') OR ((UserDB.UserTbl1.TKT_NUM =
'0813625703790') OR ((UserDB.UserTbl1.TKT_NUM =
'0813625703791') OR ((UserDB.UserTbl1.TKT_NUM =
'0813330619398') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041866') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046408') OR ((UserDB.UserTbl1.TKT_NUM =
'0060704041831') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042572') OR ((UserDB.UserTbl1.TKT_NUM =
'0550804043014') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046451') OR ((UserDB.UserTbl1.TKT_NUM =
'6561003043023') OR ((UserDB.UserTbl1.TKT_NUM =
'0813575640082') OR ((UserDB.UserTbl1.TKT_NUM =
'0430903045751') OR ((UserDB.UserTbl1.TKT_NUM =
'1760403046321') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041205') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500029894') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042594') OR ((UserDB.UserTbl1.TKT_NUM =
'2180403046442') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500041390') OR ((UserDB.UserTbl1.TKT_NUM =
'6560303041221') OR ((UserDB.UserTbl1.TKT_NUM =
'6290703043415') OR ((UserDB.UserTbl1.TKT_NUM =
'0720803049686') OR ((UserDB.UserTbl1.TKT_NUM =
'0160504047595') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203046342') OR ((UserDB.UserTbl1.TKT_NUM =
'2171103041834') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043900') OR ((UserDB.UserTbl1.TKT_NUM =
'6560703040989') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042690') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589296808') OR ((UserDB.UserTbl1.TKT_NUM =
'1251003041821') OR ((UserDB.UserTbl1.TKT_NUM =
'0430903045752') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303045701') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044249') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043353') OR ((UserDB.UserTbl1.TKT_NUM =
'1570804040600') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042555') OR ((UserDB.UserTbl1.TKT_NUM =
'2170104049609') OR ((UserDB.UserTbl1.TKT_NUM =
'2600804041234') OR ((UserDB.UserTbl1.TKT_NUM =
'9320404046000') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046453') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589688380') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589868188') OR ((UserDB.UserTbl1.TKT_NUM =
'0813330324226') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040022') OR ((UserDB.UserTbl1.TKT_NUM =
'7380303043307') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046391') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404040751') OR ((UserDB.UserTbl1.TKT_NUM =
'2600804041231') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044255') OR ((UserDB.UserTbl1.TKT_NUM =
'7810503049630') OR ((UserDB.UserTbl1.TKT_NUM =
'0160204048369') OR ((UserDB.UserTbl1.TKT_NUM =
'0160204048367') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042688') OR ((UserDB.UserTbl1.TKT_NUM =
'0813465394561') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046428') OR ((UserDB.UserTbl1.TKT_NUM =
'6560504041844') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043938') OR ((UserDB.UserTbl1.TKT_NUM =
'0720404040756') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042699') OR ((UserDB.UserTbl1.TKT_NUM =
'0570503049616') OR ((UserDB.UserTbl1.TKT_NUM =
'2170104049625') OR ((UserDB.UserTbl1.TKT_NUM =
'1600104049615') OR ((UserDB.UserTbl1.TKT_NUM =
'9990503049606') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046434') OR ((UserDB.UserTbl1.TKT_NUM =
'9990503049614') OR ((UserDB.UserTbl1.TKT_NUM =
'1250603043067') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042619') OR ((UserDB.UserTbl1.TKT_NUM =
'0060803041359') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474093134') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044422') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046411') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046354') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046357') OR ((UserDB.UserTbl1.TKT_NUM =
'0431203040927') OR ((UserDB.UserTbl1.TKT_NUM =
'0830503040926') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042697') OR ((UserDB.UserTbl1.TKT_NUM =
'0501003045717') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042696') OR ((UserDB.UserTbl1.TKT_NUM =
'0740504041044') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590355268') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589214923') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589688406') OR ((UserDB.UserTbl1.TKT_NUM =
'0570603041896') OR ((UserDB.UserTbl1.TKT_NUM =
'0140903049664') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331009509') OR ((UserDB.UserTbl1.TKT_NUM =
'2170603040991') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043328') OR ((UserDB.UserTbl1.TKT_NUM =
'0720104041816') OR ((UserDB.UserTbl1.TKT_NUM =
'0810403043328') OR ((UserDB.UserTbl1.TKT_NUM =
'1801103042633') OR ((UserDB.UserTbl1.TKT_NUM =
'0120603041004') OR ((UserDB.UserTbl1.TKT_NUM =
'6180704049615') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044257') OR ((UserDB.UserTbl1.TKT_NUM =
'0861103049719') OR ((UserDB.UserTbl1.TKT_NUM =
'2600703040927') OR ((UserDB.UserTbl1.TKT_NUM =
'0431203040932') OR ((UserDB.UserTbl1.TKT_NUM =
'0050704047695') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046372') OR ((UserDB.UserTbl1.TKT_NUM =
'5550304047661') OR ((UserDB.UserTbl1.TKT_NUM =
'0813626235904') OR ((UserDB.UserTbl1.TKT_NUM =
'0370504041291') OR ((UserDB.UserTbl1.TKT_NUM =
'6560504041304') OR ((UserDB.UserTbl1.TKT_NUM =
'0817218399916') OR ((UserDB.UserTbl1.TKT_NUM =
'2600804041233') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044246') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046409') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042559') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044240') OR ((UserDB.UserTbl1.TKT_NUM =
'0860703040000') OR ((UserDB.UserTbl1.TKT_NUM =
'0650804040124') OR ((UserDB.UserTbl1.TKT_NUM =
'0860603047252') OR ((UserDB.UserTbl1.TKT_NUM =
'0830404044201') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503040610') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044421') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042599') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589296406') OR ((UserDB.UserTbl1.TKT_NUM =
'1310204043068') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042593') OR ((UserDB.UserTbl1.TKT_NUM =
'0550704041826') OR ((UserDB.UserTbl1.TKT_NUM =
'6560504041845') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044252') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044239') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203043456') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042556') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588788158') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589179108') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203046348') OR ((UserDB.UserTbl1.TKT_NUM =
'2570803049690') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503044028') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040064') OR ((UserDB.UserTbl1.TKT_NUM =
'0720903041804') OR ((UserDB.UserTbl1.TKT_NUM =
'0120000043935') OR ((UserDB.UserTbl1.TKT_NUM =
'0813679781255') OR ((UserDB.UserTbl1.TKT_NUM =
'0813538049215') OR ((UserDB.UserTbl1.TKT_NUM =
'0860304041334') OR ((UserDB.UserTbl1.TKT_NUM =
'0140303041831') OR ((UserDB.UserTbl1.TKT_NUM =
'0140403041296') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046339') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041859') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042552') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043018') OR ((UserDB.UserTbl1.TKT_NUM =
'6560703040996') OR ((UserDB.UserTbl1.TKT_NUM =
'1760204040928') OR ((UserDB.UserTbl1.TKT_NUM =
'0370703043318') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044431') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046341') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043351') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042595') OR ((UserDB.UserTbl1.TKT_NUM =
'0720304040935') OR ((UserDB.UserTbl1.TKT_NUM =
'0010803043355') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203046031') OR ((UserDB.UserTbl1.TKT_NUM =
'6430704040938') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042574') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043352') OR ((UserDB.UserTbl1.TKT_NUM =
'9990803042400') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503044029') OR ((UserDB.UserTbl1.TKT_NUM =
'2600603046000') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473879575') OR ((UserDB.UserTbl1.TKT_NUM =
'0430903045753') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046452') OR ((UserDB.UserTbl1.TKT_NUM =
'0060803041285') OR ((UserDB.UserTbl1.TKT_NUM =
'1251003041818') OR ((UserDB.UserTbl1.TKT_NUM =
'1171003040921') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046410') OR ((UserDB.UserTbl1.TKT_NUM =
'0810804041247') OR ((UserDB.UserTbl1.TKT_NUM =
'0813082710498') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065663') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238461') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062941') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046001') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196164394') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066075') OR ((UserDB.UserTbl1.TKT_NUM =
'9990503049613') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063984') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062920') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062940') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050998') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041207') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473112339') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474172339') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058750') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500061526') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046400') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500055412') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060604') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474031976') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060049') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063027') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066136') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062954') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474297597') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062981') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050950') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500029973') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060051') OR ((UserDB.UserTbl1.TKT_NUM =
'1250503043065') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500056242') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046423') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066092') OR ((UserDB.UserTbl1.TKT_NUM =
'0720703041058') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065667') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062936') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063337') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060608') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050990') OR ((UserDB.UserTbl1.TKT_NUM =
'1760000043326') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046422') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046336') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474120699') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062969') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050989') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060077') OR ((UserDB.UserTbl1.TKT_NUM =
'7380303043306') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054948') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060628') OR ((UserDB.UserTbl1.TKT_NUM =
'0814520723027') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500056231') OR ((UserDB.UserTbl1.TKT_NUM =
'0813329873736') OR ((UserDB.UserTbl1.TKT_NUM =
'1250503043066') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054946') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500070006') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054802') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044399') OR ((UserDB.UserTbl1.TKT_NUM =
'0570603041877') OR ((UserDB.UserTbl1.TKT_NUM =
'0140403043133') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054806') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060601') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050991') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500008925') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060057') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060590') OR ((UserDB.UserTbl1.TKT_NUM =
'9990503049612') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066126') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500030036') OR ((UserDB.UserTbl1.TKT_NUM =
'0813870993562') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062953') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403889381') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054804') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500064300') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500059602') OR ((UserDB.UserTbl1.TKT_NUM =
'6430404040936') OR ((UserDB.UserTbl1.TKT_NUM =
'2170903047220') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062976') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500055472') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500025773') OR ((UserDB.UserTbl1.TKT_NUM =
'2440604041323') OR ((UserDB.UserTbl1.TKT_NUM =
'6560703040991') OR ((UserDB.UserTbl1.TKT_NUM =
'6560204044352') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500061537') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203046347') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474121073') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500064234') OR ((UserDB.UserTbl1.TKT_NUM =
'0813329873737') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062861') OR ((UserDB.UserTbl1.TKT_NUM =
'1800503043923') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500047270') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062968') OR ((UserDB.UserTbl1.TKT_NUM =
'6180503049600') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060633') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066145') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500008914') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203046015') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500029938') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060056') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500061607') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066135') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058914') OR ((UserDB.UserTbl1.TKT_NUM =
'0570303046015') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500059575') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500025804') OR ((UserDB.UserTbl1.TKT_NUM =
'0160703041230') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058973') OR ((UserDB.UserTbl1.TKT_NUM =
'6560703041013') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062977') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060078') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063981') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095473') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060104') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500068702') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046435') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054805') OR ((UserDB.UserTbl1.TKT_NUM =
'0861003042537') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500068104') OR ((UserDB.UserTbl1.TKT_NUM =
'0420704041206') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500054949') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500029972') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063026') OR ((UserDB.UserTbl1.TKT_NUM =
'0861003042535') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050987') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063338') OR ((UserDB.UserTbl1.TKT_NUM =
'0430404043062') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063678') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042566') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500061188') OR ((UserDB.UserTbl1.TKT_NUM =
'9990503049611') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589733681') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063544') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500029990') OR ((UserDB.UserTbl1.TKT_NUM =
'0570303046013') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500056202') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500066157') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500064307') OR ((UserDB.UserTbl1.TKT_NUM =
'2600804041230') OR ((UserDB.UserTbl1.TKT_NUM =
'0720404040931') OR ((UserDB.UserTbl1.TKT_NUM =
'0813870886836') OR ((UserDB.UserTbl1.TKT_NUM =
'0813870886839') OR ((UserDB.UserTbl1.TKT_NUM =
'0980404044243') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046411') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503044025') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044425') OR ((UserDB.UserTbl1.TKT_NUM =
'6430504042700') OR ((UserDB.UserTbl1.TKT_NUM =
'0160100347504') OR ((UserDB.UserTbl1.TKT_NUM =
'0420704040306') OR ((UserDB.UserTbl1.TKT_NUM =
'0140304047641') OR ((UserDB.UserTbl1.TKT_NUM =
'6770703048239') OR ((UserDB.UserTbl1.TKT_NUM =
'6560104047560') OR ((UserDB.UserTbl1.TKT_NUM =
'2200304045758') OR ((UserDB.UserTbl1.TKT_NUM =
'0141103048296') OR ((UserDB.UserTbl1.TKT_NUM =
'0370703043316') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042562') OR ((UserDB.UserTbl1.TKT_NUM =
'0550403043163') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041206') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044237') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042558') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203043467') OR ((UserDB.UserTbl1.TKT_NUM =
'0570603041890') OR ((UserDB.UserTbl1.TKT_NUM =
'1251003043111') OR ((UserDB.UserTbl1.TKT_NUM =
'0790504040459') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589442380') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044258') OR ((UserDB.UserTbl1.TKT_NUM =
'7810503049649') OR ((UserDB.UserTbl1.TKT_NUM =
'2290804040630') OR ((UserDB.UserTbl1.TKT_NUM =
'1620404042568') OR ((UserDB.UserTbl1.TKT_NUM =
'9570904040922') OR ((UserDB.UserTbl1.TKT_NUM =
'2570404045700') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041853') OR ((UserDB.UserTbl1.TKT_NUM =
'2171103041833') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589267390') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589267388') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589267391') OR ((UserDB.UserTbl1.TKT_NUM =
'0570603041894') OR ((UserDB.UserTbl1.TKT_NUM =
'6560104047522') OR ((UserDB.UserTbl1.TKT_NUM =
'2600404046412') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303043303') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046340') OR ((UserDB.UserTbl1.TKT_NUM =
'9990704042167') OR ((UserDB.UserTbl1.TKT_NUM =
'0160603041865') OR ((UserDB.UserTbl1.TKT_NUM =
'0010803043352') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044253') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041204') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042597') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042579') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042596') OR ((UserDB.UserTbl1.TKT_NUM =
'2170204049616') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042565') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041202') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046363') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046433') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331656937') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590214008') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589417591') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589417595') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590214009') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589895378') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590190785') OR ((UserDB.UserTbl1.TKT_NUM =
'0816697657657') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589895316') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589668511') OR ((UserDB.UserTbl1.TKT_NUM =
'0813330690379') OR ((UserDB.UserTbl1.TKT_NUM =
'2601103041253') OR ((UserDB.UserTbl1.TKT_NUM =
'0050803040957') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044238') OR ((UserDB.UserTbl1.TKT_NUM =
'1250503043048') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303046457') OR ((UserDB.UserTbl1.TKT_NUM =
'1760504040631') OR ((UserDB.UserTbl1.TKT_NUM =
'0160703046352') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040016') OR ((UserDB.UserTbl1.TKT_NUM =
'0010903043424') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589178956') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040011') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704042582') OR ((UserDB.UserTbl1.TKT_NUM =
'2570503047561') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095470') OR ((UserDB.UserTbl1.TKT_NUM =
'6180503049601') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589417584') OR ((UserDB.UserTbl1.TKT_NUM =
'2440604041316') OR ((UserDB.UserTbl1.TKT_NUM =
'2600204046410') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238440') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095756') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095471') OR ((UserDB.UserTbl1.TKT_NUM =
'0760303046004') OR ((UserDB.UserTbl1.TKT_NUM =
'6180703046310') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703041201') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046352') OR ((UserDB.UserTbl1.TKT_NUM =
'6560604040900') OR ((UserDB.UserTbl1.TKT_NUM =
'9990603044251') OR ((UserDB.UserTbl1.TKT_NUM =
'6560104040965') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500018501') OR ((UserDB.UserTbl1.TKT_NUM =
'1760603047566') OR ((UserDB.UserTbl1.TKT_NUM =
'1250403041838') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043323') OR ((UserDB.UserTbl1.TKT_NUM =
'6770104040971') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040008') OR ((UserDB.UserTbl1.TKT_NUM =
'2320504049609') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041869') OR ((UserDB.UserTbl1.TKT_NUM =
'0813633068530') OR ((UserDB.UserTbl1.TKT_NUM =
'7810903042451') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590088172') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041863') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590046526') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590046695') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589645856') OR ((UserDB.UserTbl1.TKT_NUM =
'0860804046316') OR ((UserDB.UserTbl1.TKT_NUM =
'1260504041052') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046345') OR ((UserDB.UserTbl1.TKT_NUM =
'0010403043335') OR ((UserDB.UserTbl1.TKT_NUM =
'0120603041006') OR ((UserDB.UserTbl1.TKT_NUM =
'2600603049673') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046353') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046361') OR ((UserDB.UserTbl1.TKT_NUM =
'0720604040952') OR ((UserDB.UserTbl1.TKT_NUM =
'0861103042658') OR ((UserDB.UserTbl1.TKT_NUM =
'2571003041068') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403888521') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044434') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044427') OR ((UserDB.UserTbl1.TKT_NUM =
'2570803049689') OR ((UserDB.UserTbl1.TKT_NUM =
'0160603041866') OR ((UserDB.UserTbl1.TKT_NUM =
'0740204040951') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044391') OR ((UserDB.UserTbl1.TKT_NUM =
'0431203040926') OR ((UserDB.UserTbl1.TKT_NUM =
'6770204041841') OR ((UserDB.UserTbl1.TKT_NUM =
'5550403044077') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303045702') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040053') OR ((UserDB.UserTbl1.TKT_NUM =
'1621003041242') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044436') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044433') OR ((UserDB.UserTbl1.TKT_NUM =
'0060404047588') OR ((UserDB.UserTbl1.TKT_NUM =
'2600804041229') OR ((UserDB.UserTbl1.TKT_NUM =
'2320504044514') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203041868') OR ((UserDB.UserTbl1.TKT_NUM =
'0530903040992') OR ((UserDB.UserTbl1.TKT_NUM =
'0810203040015') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473932985') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474212642') OR ((UserDB.UserTbl1.TKT_NUM =
'0810303045700') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046342') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238701') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331062734') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474151844') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474280299') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238412') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474183105') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500024118') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503044027') OR ((UserDB.UserTbl1.TKT_NUM =
'0010803043354') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474183106') OR ((UserDB.UserTbl1.TKT_NUM =
'0816212735080') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473976714') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474013199') OR ((UserDB.UserTbl1.TKT_NUM =
'1250403041837') OR ((UserDB.UserTbl1.TKT_NUM =
'7060403043220') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044393') OR ((UserDB.UserTbl1.TKT_NUM =
'0813590003255') OR ((UserDB.UserTbl1.TKT_NUM =
'6560504041302') OR ((UserDB.UserTbl1.TKT_NUM =
'2600803040959') OR ((UserDB.UserTbl1.TKT_NUM =
'0120603041008') OR ((UserDB.UserTbl1.TKT_NUM =
'0630404042586') OR ((UserDB.UserTbl1.TKT_NUM =
'7380404044238') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046355') OR ((UserDB.UserTbl1.TKT_NUM =
'2570704040945') OR ((UserDB.UserTbl1.TKT_NUM =
'0817281355870') OR ((UserDB.UserTbl1.TKT_NUM =
'0817281355865') OR ((UserDB.UserTbl1.TKT_NUM =
'0817281355868') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331342924') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474238413') OR ((UserDB.UserTbl1.TKT_NUM =
'6180503049602') OR ((UserDB.UserTbl1.TKT_NUM =
'7380404040452') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474239282') OR ((UserDB.UserTbl1.TKT_NUM =
'2600604044398') OR ((UserDB.UserTbl1.TKT_NUM =
'1930404041219') OR ((UserDB.UserTbl1.TKT_NUM =
'1340204041809') OR ((UserDB.UserTbl1.TKT_NUM =
'1250403041854') OR ((UserDB.UserTbl1.TKT_NUM =
'1250803047741') OR ((UserDB.UserTbl1.TKT_NUM =
'0813502189356') OR ((UserDB.UserTbl1.TKT_NUM =
'0551003040980') OR ((UserDB.UserTbl1.TKT_NUM =
'0060803041360') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589214965') OR ((UserDB.UserTbl1.TKT_NUM =
'9990703044033') OR ((UserDB.UserTbl1.TKT_NUM =
'1310703044566') OR ((UserDB.UserTbl1.TKT_NUM =
'0830204049623') OR ((UserDB.UserTbl1.TKT_NUM =
'0010803043353') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588763937') OR ((UserDB.UserTbl1.TKT_NUM =
'0815004751146') OR ((UserDB.UserTbl1.TKT_NUM =
'6031003045704') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046338') OR ((UserDB.UserTbl1.TKT_NUM =
'1250603043068') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046346') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473912919') OR ((UserDB.UserTbl1.TKT_NUM =
'0430703044034') OR ((UserDB.UserTbl1.TKT_NUM =
'1600303043059') OR ((UserDB.UserTbl1.TKT_NUM =
'2600504044378') OR ((UserDB.UserTbl1.TKT_NUM =
'1250803047740') OR ((UserDB.UserTbl1.TKT_NUM =
'6560503044030') OR ((UserDB.UserTbl1.TKT_NUM =
'0060303046492') OR ((UserDB.UserTbl1.TKT_NUM =
'2600704046362') OR ((UserDB.UserTbl1.TKT_NUM =
'0813692459807') OR ((UserDB.UserTbl1.TKT_NUM =
'1250403043137') OR ((UserDB.UserTbl1.TKT_NUM =
'0819195957535') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196062271') OR ((UserDB.UserTbl1.TKT_NUM =
'0819195957537') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196062270') OR ((UserDB.UserTbl1.TKT_NUM =
'0550903041052') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196169897') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196164397') OR ((UserDB.UserTbl1.TKT_NUM =
'0813591439453') OR ((UserDB.UserTbl1.TKT_NUM =
'0813692459805') OR ((UserDB.UserTbl1.TKT_NUM =
'0819168125692') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196038352') OR ((UserDB.UserTbl1.TKT_NUM =
'0819196062269') OR ((UserDB.UserTbl1.TKT_NUM =
'0813692459806') OR ((UserDB.UserTbl1.TKT_NUM =
'0819168125693') OR ((UserDB.UserTbl1.TKT_NUM =
'0819168125691') OR ((UserDB.UserTbl1.TKT_NUM =
'0813604044586') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060626') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065615') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065617') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500043319') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095358') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060076') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065651') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500056243') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095359') OR ((UserDB.UserTbl1.TKT_NUM =
'0813604436578') OR ((UserDB.UserTbl1.TKT_NUM =
'0811512465109') OR ((UserDB.UserTbl1.TKT_NUM =
'0813554693473') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095757') OR ((UserDB.UserTbl1.TKT_NUM =
'0813692459804') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062894') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063029') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063733') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063947') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050971') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063991') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331526478') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589609168') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589140089') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589054906') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589054908') OR ((UserDB.UserTbl1.TKT_NUM =
'0813679425588') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588729104') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060105') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500050988') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065515') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500065665') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062921') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500058604') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500060627') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062955') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500063038') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589516082') OR ((UserDB.UserTbl1.TKT_NUM =
'0814403888520') OR ((UserDB.UserTbl1.TKT_NUM =
'0816257382864') OR ((UserDB.UserTbl1.TKT_NUM =
'0814500062878') OR ((UserDB.UserTbl1.TKT_NUM =
'0813591990407') OR ((UserDB.UserTbl1.TKT_NUM =
'0817066957532') OR ((UserDB.UserTbl1.TKT_NUM =
'0812431207870') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473971093') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588874693') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473988105') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589441056') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589435055') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589778226') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589179228') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588829693') OR ((UserDB.UserTbl1.TKT_NUM =
'0813064755972') OR ((UserDB.UserTbl1.TKT_NUM =
'2320804042748') OR ((UserDB.UserTbl1.TKT_NUM =
'0813331491445') OR ((UserDB.UserTbl1.TKT_NUM =
'0814474095407') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589659718') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589387335') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589640185') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589387088') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473169579') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589442366') OR ((UserDB.UserTbl1.TKT_NUM =
'0813588964047') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049641') OR ((UserDB.UserTbl1.TKT_NUM =
'0813589144062') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003040612') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049656') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049648') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049642') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049661') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049655') OR ((UserDB.UserTbl1.TKT_NUM =
'0814473678443') OR ((UserDB.UserTbl1.TKT_NUM =
'6560304042512') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049662') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049654') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049653') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049640') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003040611') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003040613') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049647') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049650') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003040627') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049636') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049643') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049645') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049637') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049663') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049649') OR ((UserDB.UserTbl1.TKT_NUM =
'2351003049639') OR ((UserDB.UserTbl1.TKT_NUM =
'2601103041251') OR ((UserDB.UserTbl1.TKT_NUM =
'7380404044504') OR ((UserDB.UserTbl1.TKT_NUM =
'2601103041222') OR ((UserDB.UserTbl1.TKT_NUM =
'2601103041221') OR (UserDB.UserTbl1.TKT_NUM =
'9640000000000'))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
AND (UserDB.UserTbl1.JE_ACCT_PRD <= '200409')"), and the grouping identifier in field 1. Aggregate Intermediate Results are computed locally,
then placed in Spool 3. The input table will not be cached in memory, but it is eligible for synchronized scanning. The size of Spool 3 is
estimated with low confidence to be 787 rows. The estimated time for this step is 8 minutes and 40 seconds.
| |
| | 3) | We do an all-AMPs RETRIEVE step from Spool 3 (Last Use) by way of an all-rows scan into Spool 1 (group_amps), which is built locally on the
AMPs. The size of Spool 1 is estimated with low confidence to be 787 rows. The estimated time for this step is 0.07 seconds.
| |
| | 4) | Finally, we send out an END TRANSACTION step to all AMPs involved in processing the request.
| |
| | -> | The contents of Spool 1 are sent back to the user as the result of statement 1.
| |
The second query with less valeus in IN clause:
-----------------------------------------------
SELECT
TKT_NUM,
SUBSYS_REF_DTE,
SUM(CASE WHEN DR_GL_ACCT_NUM ='390256' THEN GL_DOL_AMT WHEN
CR_GL_ACCT_NUM = '390256' THEN -GL_DOL_AMT END) V390256
FROM
UserViewDB.UserView1
WHERE
TKT_NUM IN ('0814474462865',
'0814474488228',
'0814474488231',
'0814403717996',
'0816289997210',
'0816289997211',
'0813461748212',
'0813461748213',
'0814403725021',
'0814403725021',
'0814472044809',
'0814403725022',
'0814474127267',
'0814403868136',
'0814476523876',
'0814477159349',
'0814474303429',
'0814473929033',
'0814473928890',
'0814474226441',
'0813589778981',
'0814474042335',
'0814477221283',
'0814474226511',
'0814474227473')
AND JE_ACCT_PRD <= '200409'
GROUP BY 1,2
EXPLAIN for the query:
----------------------
Explanation
-------------------------------------------------- | |
| | 1) | First, we lock UserDB.UserTbl1 for access.
| |
| | 2) | Next, we do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474227473'"
extracting row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated
to be 27 rows. The estimated time for this step is 0.01 seconds.
| |
| | 3) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474226511'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 54
rows. The estimated time for this step is 0.01 seconds.
| |
| | 4) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814477221283'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 71
rows. The estimated time for this step is 0.01 seconds.
| |
| | 5) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474042335'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 97
rows. The estimated time for this step is 0.01 seconds.
| |
| | 6) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0813589778981'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 132
rows. The estimated time for this step is 0.01 seconds.
| |
| | 7) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474226441'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 159
rows. The estimated time for this step is 0.01 seconds.
| |
| | 8) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814473928890'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 185
rows. The estimated time for this step is 0.01 seconds.
| |
| | 9) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814473929033'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 211
rows. The estimated time for this step is 0.01 seconds.
| |
| | 10) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474303429'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 238
rows. The estimated time for this step is 0.01 seconds.
| |
| | 11) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814477159349'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 255
rows. The estimated time for this step is 0.01 seconds.
| |
| | 12) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814476523876'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 277
rows. The estimated time for this step is 0.01 seconds.
| |
| | 13) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814403868136'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 293
rows. The estimated time for this step is 0.01 seconds.
| |
| | 14) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474127267'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 319
rows. The estimated time for this step is 0.01 seconds.
| |
| | 15) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814403725022'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 335
rows. The estimated time for this step is 0.01 seconds.
| |
| | 16) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814472044809'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 351
rows. The estimated time for this step is 0.01 seconds.
| |
| | 17) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814403725021'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 367
rows. The estimated time for this step is 0.01 seconds.
| |
| | 18) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0813461748213'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 387
rows. The estimated time for this step is 0.01 seconds.
| |
| | 19) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0813461748212'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 407
rows. The estimated time for this step is 0.01 seconds.
| |
| | 20) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0816289997211'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 429
rows. The estimated time for this step is 0.01 seconds.
| |
| | 21) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0816289997210'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 451
rows. The estimated time for this step is 0.01 seconds.
| |
| | 22) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814403717996'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 467
rows. The estimated time for this step is 0.01 seconds.
| |
| | 23) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474488231'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 494
rows. The estimated time for this step is 0.01 seconds.
| |
| | 24) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474488228'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 521
rows. The estimated time for this step is 0.01 seconds.
| |
| | 25) | We do a single-AMP RETRIEVE step from UserDB.UserTbl1 by way of the primary index "UserDB.UserTbl1.TKT_NUM = '0814474462865'" extracting
row ids only with no residual conditions into Spool 4 (all_amps), which is built locally on that AMP. The size of Spool 4 is estimated to be 536
rows. The estimated time for this step is 0.01 seconds.
| |
| | 26) | 26) We do a SORT to order Spool 4 by row id eliminating duplicate rows. The estimated time for this step is 0.01 seconds.
| |
| | 27) | We do an all-AMPs SUM step to aggregate from UserDB.UserTbl1 by way of row ids from Spool 4 (Last Use) with a residual condition of
("UserDB.UserTbl1.JE_ACCT_PRD <= '200409'"), and the grouping identifier in field 1. Aggregate Intermediate Results are computed globally, then
placed in Spool 3. The input table will not be cached in memory, but it is eligible for synchronized scanning. The size of Spool 3 is estimated
with low confidence to be 31 rows. The estimated time for this step is 0.60 seconds.
| |
| | 28) | We do an all-AMPs RETRIEVE step from Spool 3 (Last Use) by way of an all-rows scan into Spool 1 (group_amps), which is built locally on
the AMPs. The size of Spool 1 is estimated with low confidence to be 31 rows. The estimated time for this step is 0.07 seconds.
| |
| | 29) | Finally, we send out an END TRANSACTION step to all AMPs involved in processing the request.
| |
| | -> | The contents of Spool 1 are sent back to the user as the result of statement 1.
| |
This is Single AMP Retrieve.
Inference:
----------
Does this mean the user will get results faster by submitting the values in batches???
Not too sure!!!
My aplogies for sending such a long mail, but could not find a better way to send it. ;-)
Thanks & Regards,
Pete
| |
