Archives of the TeradataForum

Message Posted: Fri, 07 Nov 2003 @ 11:45:30 GMT

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

I've just started using teradata for my application. Would like to know whether like oracle can we use function indexes in terdata?

E.g,
If my where clause goes like

WHERE
A=A1
AND
B=B1
AND
ltrim(C) = C1 ;

Can I create an index on A,B and ltrim(C) or can I create an index just on ltrim(C) ?

From what I can understand an index created on combo of A,B,C would not be used by the optimiser because of ltrim .

Regards,

Milan Atreya

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