• One of the things I have come across is that *not* prefixing or suffixing tables AND views may save the day on databases with large tables.

    You maybe wondering "why?". Well you could change a table into a partitioned view ( with no client side changes ) or change a view into a table for materialization purposes ( again with no client-side changes)

    These scenarios are not that uncommon and is something you may want to keep in mind.

    Cheers,


    * Noel