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 are packages in pl sql and also explain its advantages?
What are the benefits of triggers?
What are inner and outer joins examples of both?
Write a query to display the current date in sql?
What are synonyms in sql?
How does cross join work?
Describe types of sql statements?
What is index example?
What is a recursive stored procedure?
what are the t string functions available in tsql? : Transact sql
What is a string data type in sql?
What is data manipulation language?
Why do we use function in pl sql?
What is server name sql?
Explain the uses of database trigger.
