Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2006 @ 21:37:18 GMT

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

The question is not how many records, but "When does it improve performance of a query that occurs with some frequency." Which can be answered if you know (or collect) your queries and if you run the Explains to prove that the secondary index is used. Otherwise, never.

iv

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