SQL for Data Analysis

11.

Views and Temporary Objects

11.1.

11.1.1.

11.1.2.

11.1.3.

11.1.4.

11.1.5.

Updatable Views

11.1.6.

View Dependencies

11.1.7.

View Security Benefits

11.2.

Materialized Views

11.2.1.

Materialized View Concepts

11.2.2.

Creating Materialized Views

11.2.3.

Refreshing Materialized Views

11.2.4.

Query Rewriting with Materialized Views

11.2.5.

Performance Benefits

11.3.

Temporary Tables

11.3.1.

Local Temporary Tables

11.3.2.

Global Temporary Tables

11.3.3.

Creating Temporary Tables

11.3.4.

Temporary Table Scope

11.3.5.

Performance Considerations

11.4.

Table Variables

11.4.1.

Declaring Table Variables

11.4.2.

Table Variables vs Temporary Tables

11.4.3.

Use Cases for Table Variables

Previous

10. Set Operations and Advanced Queries

Go to top

Next

12. Advanced Data Types and Semi-Structured Data