Search found 1 match

by jonhsame
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...

Go to advanced search