patternMinor
Tablespace consumed by views
Viewed 0 times
viewstablespaceconsumed
Problem
I was in an SQL class where the instructor said "DBAs don't like it when users create views, because they will clobber tablespace."
Obviously, I understand that any schema object will consume some tablespace, but isn't it a huge exaggeration to say that views will eat up tablespace, since all you need to store is just a query (and privileges and some other metadata), and as such they won't take significantly more space than an ordinary row in an ordinary table?
Obviously, I understand that any schema object will consume some tablespace, but isn't it a huge exaggeration to say that views will eat up tablespace, since all you need to store is just a query (and privileges and some other metadata), and as such they won't take significantly more space than an ordinary row in an ordinary table?
Solution
Not true, unless they meant "materialised views"
Permanent tablespaces are used to store user data and user created objects like tables, indexes and materialized views.
- ORAFAQ
Permanent tablespaces are used to store user data and user created objects like tables, indexes and materialized views.
Context
StackExchange Database Administrators Q#4930, answer score: 5
Revisions (0)
No revisions yet.