Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 16:14:25 GMT

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

In V2R5, there is new Feature: Stats on Multiple columns in a single pass (1 statement). In this case, DBC.INDEXES table will get updated with INDEXTYPE as "M".

DBC.INDICES view is created from DBC.INDEXES and with other tables with IDEXTYPE <> "M". I need the similar view with INDEXTYPE ="M".

Since I need to data with INDEXTYPE = 'M' for my process. I am wondering is there any view already exists in DD or new view to be created for my process.

Thanks

Venkat

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