1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Yes, you can identify the disk space occupied by materialized views (MVs) in your database. These are the way you can do it :-
Query the System View, Analyze Table Size: You can use SQL queries to analyze the size of the tables underlying the materialized views. Since materialized views store the result of a query as a table, you can query the underlying tables to determine their size and calculate the total size of the MVs.
Database Management Tools , Database Documentation https://docs.aws.amazon.com/redshift/ :- Check the documentation of your specific database system for information on how to analyze disk space usage, including materialized views.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전