Answer Posted / kapil syscom
View is simple structure as table in database, it dosen't take extra memory space, and reduces the structural complexity of database whenever we need to fetch the data from more than one table, thus it reduces the cost of joins every time.
Thus these is true that we have to use it for efficiency reasons..
Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the difference between delete, truncate and drop command?
What is data type in sql?
What is character functions?
What is multiple partition?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is a function in oracle pl sql?
Why are sql stored procedures used?
What is clause in sql?
what are properties of a transaction? : Sql dba
What are the two different parts of the pl/sql packages?
How can we link a sql database to an existing android app?
What is the use of partition by in sql?
What is a string data type in sql?
What is the need of merge statement?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba