Archives of the TeradataForum

Message Posted: Wed, 24 Jul 2002 @ 14:41:14 GMT

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

I know that some sites have parts of Access Logging turned on to capture SQL that is submitted. I've also heard that some sites have changed the Primary Index to TheDate, TheTime, rather than LogonDate, LogonTime which has caused serious hot amp problems at some sites.

So, what I'm asking is how do you change the PI (since DBC doesn't seem to have drop table).

And, what do you put into AccessLogRights?

Thanks.

Sam Sterling

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