How to check View size in Teradata

Database

How to check View size in Teradata

In Teradata DB, generally expectation would be to get the data size for a table, but for my task I need to identify size of a View. This view contains joins from 3 different tables and all I could identify is the count of the View - 757747 records now. Reason behind this is to determine data file size for export and use it in another DB.

Should I directly use this count and apply formula to determine it size?. If so what would be formula, is it sum(currentperm) I am confused, please advise

- Rakz


In Teradata DB, generally expectation would be to get the data size for a table, but for my task I need to identify size of a View. This view contains joins from 3 different tables and all I could identify is the count of the View - 757747

Should I directly use this count and apply formula to determine it size?. If so what would be formula, is it sum(currentperm) I am confused, please advise



Tags (2)