This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.