Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2012 @ 20:15:49 GMT


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

Subj:		Re: Select statement not throwing error

From:		Nimmala, Meher

Hi Rajani,

Please check explain plan. Optimizer assumes, you are passing a value of 1234, 2222, 3333 and 4444555566667777. So it does not throw any error.

For example

     SELECT * FROM EMPLOYEE
     WHERE EMPLOYEE_SEQ IN
     ('2339219'
     ,'3011745'
     '1517526'
     '3037031')

`Explanation --------------------------------------------------`
	`1)`	`First, we do a single-AMP RETRIEVE step from RbdwMarqueetbls.EMPLOYEE by way of the unique primary index "RbdwMarqueetbls.EMPLOYEE.EMPLOYEE_SEQ = 301174515175263037031. " with no residual conditions into Spool 1 (group_amps), which is built locally on that AMP. The size of Spool 1 is estimated with high confidence to be 1 row (119 bytes). The estimated time for this step is 0.02 seconds.`
	`2)`	`Next, we do a single-AMP RETRIEVE step from RbdwMarqueetbls.EMPLOYEE by way of the unique primary index "RbdwMarqueetbls.EMPLOYEE.EMPLOYEE_SEQ = 2339219" with no residual conditions into Spool 1 (group_amps), which is built locally on that AMP. The size of Spool 1 is estimated with high confidence to be 2 rows (238 bytes). The estimated time for this step is 0.02 seconds.`
	`3)`	`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.`

Regards,

Meher


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