Registration is open for Inspire 2024! For today only receive up to 20% off. This promotion is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes. Register here!
Please add the ability to specify indexes when creating a table with the Write Data In-DB tool.
When running Teradata SQL using the Connect In-DB tool I need to create a table on the database using the Write Data In-DB tool and do numerous updates before bringing the data to the PC. Currently there is no way to create a unique primary index (or any other index) when the Write Data In-DB tool creates a table. This causes Teradata to consume huge amounts of wasted space. Today I created a table with 160 columns and 50K rows. This consumed over 20 Gigabytes of data with 19.7 Gigabytes of wasted space. In Teradata the way to control wasted space(skew) is by properly defining the index which can't be done today.