Archives of the TeradataForum
Message Posted: Tue, 23 Feb 2010 @ 09:50:34 GMT
Can you please explain how the rows will be physically accessed for the following query?(using hashmap etc.)
Select * from Employee Where empno not in (1,2,3,4)
Here employee is the table name and empno is the primary index.
p.s: note, here not in condition is used in filter.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|