Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2001 @ 15:30:53 GMT

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

Subj:   Re: Import causing all-amp operation
From:   Dieter N�th

Hi Shelly,

are you really shure about the all-amp access? I just run you're script, and it's OK. When i use more sessions it's running faster, so it can't be a FTS or NUSI access. When i explain the macro it's doing a single amp delete step, as it's supposed to do: It's doing implicit typecasts, casting e.g '1223' to integer, and so it's possible to calculate the RowHash of the PI and access using the NUPI.

So, when you explain the macro, it's also doing a single amp delete step? And when you use it from a bteq import, not?

This is supposed to be impossible ;-)


  <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: 15 Jun 2023