Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 23:10:22 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016