Archives of the TeradataForum
Message Posted: Thu, 21 Feb 2002 @ 20:08:08 GMT
Retcancel only tell the query to throw away the remaining rows at the PE after the first 100 rows.
If you want it speed up the query, you need to use sample 100 in your query.
It still will run a little longer than you might think but should be much faster than your approach. Assumes V2 R3.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|