Search found 1 match
- Fri Oct 21, 2016 5:59 am
- Forum: New to Vertica Database Administration
- Topic: How do I find all on used projections?
- Replies: 1
- Views: 17021
How do I find all on used projections?
Hi guys, I am trying to clean up my database and want to find all the unused projections. Is the following query an accurate way to find them? bi quyet lam giau select projection_name, projection_schema, anchor_table_name from projections where projection_name not in (select projection_name from pro...