How would you check what version of teradata is being used in your UNIX env?
You simply have to create a bteq script:
And run the script.
Or, you can do the same on commandline.
OR you can always run the query:ReplyDelete
SELECT * FROM DBC.DBCINFO;
u r given good information tips for us.ReplyDelete
i have one doubt ,we r creating volatile table for intermediate calculation but it take lot of time. how to tune this table,PLS give me some tips to solve this problem.
thanks & regards
Make sure you have chosen the right Primary Index. Based on the data distribution and also based on how you will join with this table in future.
You could run explain on your sql and see which step takes more I/O, and try to tune that step.
Hope this helps.
how we delete parent table if the parent table having relation ship with child tableReplyDelete