Naming conventions for views and materialized views: “*_v”, “v_*”, “*_mv”, “mv_*” or none?

My view stores quality metrics for various gizmos1 in the database. Today I designed it to be a view. In a few years, as we produce more gizmos, it may need to be changed to a materialized view. I was thinking of naming the view either of these 3 ways: gizmo_quality_metrics gizmo_quality_metrics_v v_gizmo_quality_metrics Which one … Read more