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 are all the common sql function? : Sql dba
Can we use distinct and group by together?
Does group by remove duplicates?
what are the advantages of sql ? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is your daily office routine?
what is sql server agent? : Sql dba
What is the current version of postgresql?
Can delete statement be rollbacked?
What is the current version of sql?
Is primary key clustered index?
If a cursor is open, how can we find in a pl/sql block?
what is collation? : Sql dba
Can we rollback truncate?
what is schema? : Sql dba
