View & Materialized View

-

Comparison Chart

BASIS FOR COMPARISONVIEWMATERIALIZED VIEW
BasicA View is never stored it is only displayed.A Materialized View is stored on the disk.
DefineView is the virtual table formed from one or more base tables or views.Materialized view is a physical copy of the base table.
UpdateView is updated each time the virtual table (View) is used.Materialized View has to be updated manually or using triggers.
SpeedSlow processing.Fast processing.
Memory usageView do not require memory space.Materialized View utilizes memory space.
SyntaxCreate View V AsCreate Materialized View V Build [clause] Refresh [clause] On [Trigger] As

Comments

Post a Comment

Popular posts from this blog

Spring Boot + Maven + RestFul + JPA + Sqlite

-
1. pom.xml  :- <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.wfd</groupId> <artifactId>springDemo</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>jar</packaging> <name>springDemo</name> <description>Demo project for Spring Boot</description> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.0.4.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <properties> <project.build.sourceEncod...
Read more

Java Basics

-
Java Basics :- --------------- Java variables Data types Variables:- Variables are containers for storing data values. In Java, there are different types of variables, for example: String - stores text, such as "Hello". String values are surrounded by double quotes int - stores integers (whole numbers), without decimals, such as 123 or -123 float - stores floating point numbers, with decimals, such as 19.99 or -19.99 char - stores single characters, such as 'a' or 'B'. Char values are surrounded by single quotes boolean - stores values with two states: true or false Declaring Variables :- Syntax : type variable = value; Data Types : - it specify Type of data Primitive Data Types : A primitive data type specifies the size and type of variable values, and it has no additional methods. There are eight primitive data types in Java: Data Type Size         Description byte               1 byte Stores ...
Read more