Interested to Buy Any Domain ? << Click Here >> for more details...
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 clustered and non-clustered indexes?
how would you enter characters as hex numbers? : Sql dba
Is there any restriction on the use of union in embedded sql?
What is the non-clustered index in sql?
What is a temporal table?
What is t sql used for?
What is left join example?
How is data stored in sql?
What can I use instead of union in sql?
Differentiate between sga and pga.
What is the use of function "module procedure" in pl/sql?
what is bcp? When does it used? : Sql dba
How does cross join work in sql?
what are dynamic queries in t-sql? : Transact sql
What does over partition by mean in sql?
