Archives of the TeradataForum
Message Posted: Tue, 01 Feb 2005 @ 11:01:54 GMT
The answer depends on the release. In V2R4, queries start failing when the total size of the IN LIST values approaches something like 1MB. I quote the limit from memory. It might depend on some system settings on your as well. A typical error message would indicate that the maximum number of plastic steps has been exceeded.
In V2R5, queries with long value lists are being rewritten by the optimizer. They don't fail but the execution plan might change significantly, and the queries might get slower.
There is a recent thread in the archives where somebody from NCR advised that in future releases a temporary table will be created on the fly and the query will be internally rewritten to have an extra join to it. Unfortunately, I cannot find the thread via Google. You might have more luck by browsing the thread titles over the last 3-4 months.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|