Archives of the TeradataForum

Message Posted: Fri, 31 Mar 2006 @ 19:08:38 GMT

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

Sorry for the delay, but it's been a busy week.

I did the work for a customer so do not think it appropriate that I distribute their requirements or code.

But, the implementation is relatively simple and I am sure you or your DBA's will already be doing something very similar - perhaps not with Stored Procedures yet. BUT you really must understand your requirements.

Once you know your requirements, build a table to reflect what you need to know. For example, if you want to collect a mixture of Sample and Full statistics, you need a column to indicate that. If you want to collect stats on different days of the week, you need another column(s) to indicate that.

Then, in the SP, you read the table to build the SQL statement that you then execute.

Hope that helps,

Keith.

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