Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 17:20:11 GMT

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

Can you send the explain text of the query?

Because I've tried to simulate your query and your table, in this way:

     CREATE SET volatile TABLE lkp_articulo_aux ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           cd_articulo CHAR(13),
     descripcion CHAR(1))
     unique PRIMARY INDEX  ( cd_articulo, descripcion)
     on commit preserve rows;

     EXPLAIN select distinct cast(
     cast(cd_articulo as char(13)) ||
     cast(descripcion as char(1)) as char(14)
     )
     from lkp_articulo_aux
     where cd_articulo not in ('0210000000010','')
     ;

       1) First, we do an all-AMPs RETRIEVE step from
          SFE043.lkp_articulo_aux by way of an all-rows scan with a
          condition of ("(SFE043.lkp_articulo_aux.cd_articulo <> ' ') AND
          (SFE043.lkp_articulo_aux.cd_articulo <> '0210000000010')") into
          Spool 1 (group_amps), which is redistributed by hash code to all
          AMPs.  Then we do a SORT to order Spool 1 by the sort key in spool
          field1 eliminating duplicate rows.  The size of Spool 1 is
          estimated with no confidence to be 1 row.  The estimated time for
          this step is 0.03 seconds.
       2) 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 total estimated time is 0.03 seconds.

But I'm not getting a Single-AMP query...

B-ye.

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