A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
does views take any space in database?
Joined: Nov 25, 2008
Jul 17, 2011 12:23:29
Below is the question i got in exam.
4) What are the space requirements for views? • Views require the space used to store a few records in various system tables • Views do not store data and therefore use no space • Views require as much space as would a table that presented the same data • Views require as much space as all the tables they are created from.
I maked 2 as answer, but the answer is wrong.So that means views take space in database .Is it correct ?
Joined: Mar 22, 2005
Jul 17, 2011 12:25:53
Yes, they do. Not for data, but for the description of the view - making answer #1 the correct one.
author & internet detective
Joined: May 26, 2003
Jul 17, 2011 18:21:05
Additionally, some databases like Oracle support materialized views. These require space for the data as well.
OCA 8 book
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
subject: does views take any space in database?
Is my MVC design under RMI reasonable?
Runtime intermediate storage - Design Problem
query a resultset like CFQUERY
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015