Archives of the TeradataForum

Message Posted: Mon, 04 Mar 2002 @ 08:46:02 GMT

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

Petr,

I don't think there are any technical reasons why you couldn't do this -- although you may need to stay away from the non-hashed tables. I also can't think of a reason why you shouldn't. These tables are 'just' database tables that are involved in queries which have to be optimised, and collected statistics are one way of helping the optimiser to get the best join/access plan.

The optimiser does have some hooks/special processing for some system tables but the stuff that I'm aware of is mainly to do with automatically setting an access lock on tables etc. I suppose it is possible that the optimiser will ignore stats on system tables (although I doubt it) -- only trial and error or someone from ncr can confirm that.

I'm guessing that you're mainly thinking of the frequently accessed tables -- tvm, dbase, resusage???? etc etc -- and I can't see any reason why you shouldn't collect stats on these.

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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