I'm having trouble to find all possible ways to call specific partitions of a partitioned table, in Teradata. I need to find eventual usage of partition calling in Teradata files, and I need to cover every case to be sure it is or not used.
I know things like
SELECT *, PARTITION
FROM my_table
WHERE PARTITION = 3;
can exist, but I don't know if that is the only possibility.
I'm looking for resources or a list of usage cases. Thanks!