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
How would you convert date into julian date format?
Is pl sql different from sql?
How we can update the view?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is sql performance tuning?
How do I view stored procedures?
Does group by remove duplicates?
What is a sql driver?
What is dialect in sql?
What is difference between sql and mysql?
How do I edit a trigger in sql developer?
What is trigger point?
What is varchar data type in sql?
What is sql scripting?
How do you select unique values in sql?
