Interested to Buy Any Domain ? << Click Here >> for more details...
What is the differnce between view and materialized view
- 4 Answers
- 9142 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / papia
view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is better join or subquery?
How is indexing done in search engines?
How do you write a subquery?
How can you select unique records from a table?
Differentiate between syntax and runtime errors.
Why stored procedure is faster than query?
Does sql*plus also have a pl/sql engine?
what is a database lock ? : Sql dba
What are the popular database management systems in the it industry?
what are local and global variables and their differences? : Sql dba
Does normalization improve performance?
What is cte sql?
What is sequence in sql?
What is having clause in sql?
How delete all records from table in sql?
