Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 19:11:31 GMT

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

Pat,

We have a bunch of compound indices like (trxn date, shop) and (trxn date, item_nbr)on our tables. When does these indexes get utilised? Is it only when you specify a particular value for each column or does the optimizer use this index when you specify a range of values for these columns like using between clause on a date column?

I did explain on some of our queries and i do not see these compound indices being used! Since tables which have these indices are quite big and optimizer uses these only in very few cases is it worth to drop these?

Harish

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