How to check view size in teradata?

Member

by larissa , in category: MySQL , 20 days ago

How to check view size in teradata?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by jasen_gottlieb , 20 days ago

@larissa 

To check the view size in Teradata, you can use the following steps:

  1. Connect to your Teradata database using a SQL client or Teradata SQL Assistant.
  2. Run the following SQL query to display all views and their sizes in the database:
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
SELECT DatabaseName,
       TableName,
       CASE
           WHEN TableKind = 'V' THEN 'View'
           WHEN TableKind = 'T' THEN 'Table'
           ELSE 'Other'
       END AS TableKind,
       SUM(CurrentPerm) AS TotalPerm
FROM DBC.TableSizeV
GROUP BY 1,2,3
ORDER BY 1,2;


This query will return a list of views along with their respective database name, table name, table kind (view or table), and total size in current permanent space (CurrentPerm) units.

  1. Check the "TotalPerm" column in the query result to view the size of each view in the database.


By following these steps, you can easily check the size of views in your Teradata database.