A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?

Answer Posted / kriish

Views do no take memory in database they are just window through data is shown to user from table

Is This Answer Correct ?    17 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is save point in oracle database?

716


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1459


How do I use os authentication with weblogic jdriver for oracle and connection pools?

564


What is the difference between postgresql and oracle?

498


what are bitmap indexes? How does they work?

1709






In what script is snap$ created? In what script is the scott/tiger schema created?

2232


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1739


What happens to the indexes if a table is recovered?

568


What are the various oracle database objects?

667


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1622


How to drop an index in oracle?

594


Explain the use of indexes option in imp command.

557


What is Trigger in Oracle?

563


What is null value in oracle?

620


What are the parameters that we can pass through a stored procedure?

544