How do I find all on used projections?
Posted: Fri Oct 21, 2016 5:59 am
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
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
Code: Select all
select projection_name, projection_schema, anchor_table_name from projections
where projection_name not in (select projection_name from projection_usage)
order by projection_name, projection_schema, anchor_table_name;