Interested to Buy Any Domain ? << Click Here >> for more details...
What are different types of refreshment techniques of
materialised view
- 2 Answers
- 8191 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankush seth
three types of refreshment techniques for materialised
view
1)Fast refresh
2)Force refresh
3)Complete refresh
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rajesh venati
The above one good,
There are Three Types of Refreshment Techniques in
Materialized View.
They are,
1. Fast Refresh
2. Force Refresh
3. Complete Refresh
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between joins?
What is pl sql in oracle?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
What is audit logout in sql profiler?
How do I add a primary key to a table?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How do you select unique values in sql?
What is the use of a view in sql?
How many commands are in sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is the use of sqlerrd 3?
Which is faster count (*) or count 1?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
