All Forums Database
samit_9999 37 posts Joined 03/06
17 Apr 2006
Function Based Indexes?

Can you create Function Based Indexes in Teradata , as you do in Oracle.I have collected Stats on a particular column "ABC". However when i do a substr on "ABC" and join it with a column "XYZ" in a different table , its taking a long time.What can be the problem?Please helpThanks,Sam

You must sign in to leave a comment.