 |
 |
Archives of the TeradataForum
Message Posted: Fri, 07 Nov 2003 @ 14:15:37 GMT
| Subj: | | Re: Function indexes in Teradata |
| |
| From: | | Victor Sokovin |
On Fri, 7 Nov 2003 06:45:30 -0500, Milan Atreya wrote:
| | I've just started using teradata for my application. Would like to know whether like oracle can we use function indexes in
terdata? | |
Function indexes do not exist in Teradata as yet.
| | 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)? | |
Neither of these.
| | From what I can understand an index created on combo of A,B,C would not be used by the optimiser because of ltrim . | |
That's correct. I think the best take would be an index on A and B.
Regards,
Victor
| |
