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 lookup table in sql?
What do you mean by table in sql?
Can we join more than 2 tables in sql?
How do I start pl sql?
How do I run a sql query?
Can we use pl sql in mysql?
What is the purpose of design view?
What does count (*) mean?
Which sql statement is used to return only different values?
Is sql similar to python?
describe mysql connection using mysql binary. : Sql dba
How do temporal tables work?
What are the different ddl commands in sql?
Which tcp/ip port does sql server run?
Which nosql database is best?