Operate with Database Objects

• Basic Queries
• Create and Manage indexes
  • Index types
  • Manage indexes
  • Index-only scan and covering index
  • Backward index scan
  • Check index usage
• Create and Manage Warehouses
  • Check existing warehouses
  • Create a warehouse
  • Set and use a warehouse
  • Change the size of a warehouse
  • Optimize query execution for warehouses
  • Stop a warehouse
  • Resume a warehouse
  • Delete a warehouse
• Create and Manage Tables
  • Create a table
• Create and Manage Views
  • Create views
  • Drop views
  • Best practices when creating views
• Create and Manage Materialized Views
  • Create materialized views
  • Refresh or deactivate materialized views
  • Drop materialized views
  • Automatically use materialized views for query optimization
• Insert, Update, and Delete Row Data
  • Insert rows
  • Update existing rows
  • Delete rows
  • Vacuum the database
• Use Tags to Manage Database Objects
  • Features of tags
  • Usage scenarios
  • Use tags
  • System tables related to tags
  • Common errors and tips
• Data Branching
  • What it is: manage data like Git
  • What it’s for: efficient, isolated, zero-cost data snapshots
  • Use cases
  • How to use
  • Considerations