• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

does views take any space in database?

 
sam liya
Ranch Hand
Posts: 1240
  • 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
Pie
Posts: 42967
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
Marshal
Posts: 34071
331
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