Archives of the TeradataForum

Message Posted: Fri, 29 Jun 2001 @ 13:48:06 GMT

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

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,

Jon.

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