Difference between a View and Materialized View in oracle.
Difference between a View and Materialized View in oracle.View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables. It points to the data of the joined tables rather than the data itself. On the other hand, materialized views have the data itself. This makes it easier and faster to access. It contains pre-computed aggregated information.
|
Define primary key and foreign keyDefine primary key and foreign key - A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key....