At my workplace I can't create permanent tables, so I have been creating volatible tables as middle steps for joins later on very large data set.
I would like to order the dataset by group name and effective date, but the order option isn't allowed for volatile table (FYI, I have version 14.10). Is there a way I can sort the data so that I can use it for faster join and easier data manipulation?
Below is a sample code. Please let me know if I can sort the table through another method or if there is a more efficient method.
First of all having an order by won't help in faster joins. Teradata stores the table completely in a different order based on hashing on primary index. If you would like to see performance, consider using group and eff date as primary index.