SQL for Data Analysis
View Concepts
Creating Views
Simple Views
Complex Views
Updatable Views
View Dependencies
View Security Benefits
Materialized View Concepts
Creating Materialized Views
Refreshing Materialized Views
Query Rewriting with Materialized Views
Performance Benefits
Local Temporary Tables
Global Temporary Tables
Creating Temporary Tables
Temporary Table Scope
Performance Considerations
Declaring Table Variables
Table Variables vs Temporary Tables
Use Cases for Table Variables
Previous
10. Set Operations and Advanced Queries
Go to top
Next
12. Advanced Data Types and Semi-Structured Data