Archives of the TeradataForum

Message Posted: Wed, 31 Mar 2004 @ 19:27:43 GMT

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

Selectivity = (# of rows returned)/(total # of rows)

The selection criteria that returns a small number of rows is said to be highly selective.

The selection criteria that return a large number of rows are said to have low selectivity.

I'm confused , if TableA has 1 miliion rows , suppose particualr NUSI returns 1000 rows , from the formula above

selectvity = 1000/1000000 = .001 , so this has less selectivity , but low selectivity means returning large #of rows . So .001 selecitivity is high or low ?

Thanks,

Rick

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