How do you improve the Query performance in Teradata? I know that in ORACLE we use the HINTS. Can some one tell me the Tips/Tricks?
[b]Question asked by visitor Nithin[/b]
Printable View
How do you improve the Query performance in Teradata? I know that in ORACLE we use the HINTS. Can some one tell me the Tips/Tricks?
[b]Question asked by visitor Nithin[/b]
[QUOTE=Geek_Guest;15363]How do you improve the Query performance in Teradata? I know that in ORACLE we use the HINTS. Can some one tell me the Tips/Tricks?
[b]Question asked by visitor Nithin[/b][/QUOTE]
by collecting statistics on the column .u can improve the performance
definately, collecting stats is very effective.... You can also try using GTT tables. If a query is long and have lots of joins and derived tables.. GTT is the best option. Because you cannot use collect stats on derived columns.