Archives of the TeradataForum

Message Posted: Thu, 24 May 2007 @ 15:57:54 GMT

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

Hi,

it's very simple.

You must create Extended Atribute "IsGenerated" for index in Teradata.xdb (Profile --> Index). Next step is inserting 2 rows:

     [%IsGenerated%?create [%UNIQUE% ]index[%NamedIndex%?
     %INDEX%][%AllIndex%? all] ( %CIDXLIST% )[ order by
     (%OrderByColumnList%)] on %TABLE%;]
     collect statistics on %TABLE% column ( %CIDXLIST% )

to section Object --> Index --> Create...

Then all indexes have statistics and from nongenerated (IsGenerated = false) indexes is only statistic.

Kind Regards

J. Basler

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