Archives of the TeradataForum
Message Posted: Fri, 07 Nov 2003 @ 11:45:30 GMT
I've just started using teradata for my application. Would like to know whether like oracle can we use function indexes in terdata?
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 .
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|