• Post Reply Bookmark Topic Watch Topic
  • New Topic

does views take any space in database?  RSS feed

 
sam liya
Ranch Hand
Posts: 1246
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Below is the question i got in exam.



I maked 2 as answer, but the answer is wrong.So that means views take space in database .Is it correct ?
 
Ulf Dittmer
Rancher
Posts: 42970
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, they do. Not for data, but for the description of the view - making answer #1 the correct one.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36443
454
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Additionally, some databases like Oracle support materialized views. These require space for the data as well.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!