Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 31 Jul 2015 @ 16:26:36 GMT

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

Subj:   Re: Row Limit at User Level
From:   Walter, Todd

There is not a system or user option.

It is possible to monitor queries like this by reviewing DBQL where the number of result rows is logged.

A feature to do this is on the consider list but not planned for a specific release or date at this time. In discussing this, we have observed that this feature is at best a stopgap. If users are restricted to 10,000 rows for instance, then a determined user will run multiple queries to retrieve 9,999 rows at a time. This might already be happening to try to stay under the radar. The way to capture this behavior is again to go to the DBQL logs and look not only at single queries returning large results but also look for continuing patterns of large to medium extractions where the users should not be doing so.

  <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: 24 Jul 2020