We have a set of tables in production, created with PPI with partition definded on a CHAR (4) column long time back. Now We receive multiple requests throughout the year to add More values to the partition and we are constantly touching the DDL of the Table to modify the partition and the DDL looks really lengthy now. And we also have a strong feeling that those partitions are never or Sparingly used in the SQL's that consume the data from these tables.
Is there anyway we can get the usage of the Partition columns in the SQLs. Basically we are trying to re-evaluate the need of partition on those tables, Is there are any way to do that from Log tables or any utilities of Teradata will help ?