Archives of the TeradataForum
Message Posted: Fri, 29 Jun 2001 @ 13:48:06 GMT
I can not remember if this has been mentioned for this thread - but if you are using the ODBC to connect (via SAS, or MS Access, etc) - ODBC tends to turn "bulk" requests into insert selects, one per row. Try and use "pass through" SQL where appropriate.
If this is unavoidable, and there is enough space on your system, copy the days log entries to another database, and then delete those entries from the DBC. This will, at least, improve the dictionary performance. Plus allow any analysis against the table to be performed away from the dictionary. From here you can opt to improve the index on the access log history table created.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|