3 ms·
What's the problem with views?
by moehm 7y ago
What's the problem with views?
- tensor 7y agoYou can't insert/update/delete data in views in all cases, and they can make debugging performance more challenging, but otherwise nothing. I think they are underused. I rarely see people using views at all, let alone using them as a test aid (composing big queries from smaller more easily tested views), or using them to define interfaces to an internal data model.
- miles-po 7y agoFor the most part, you can insert/update/delete. See: INSTEAD OF triggers. That is unless you're using MySQL/MariaDB, in which case views are the least of your worries.