Archives of the TeradataForum

Message Posted: Thu, 17 May 2012 @ 09:00:45 GMT

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

Hi Experts,

While creating secondary index, if we gibe order by hash, what will be the impact?

How it can speed up the data retrieval?

Eg :

     CREATE INDEX proddimid ( END_DT ,DIVN_NBR ) ORDER BY HASH ( END_DT );

Thanks,

Sughesh I S

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