filmov
tv
Data Architecture: Using the Query Plan Tool to Understand Query Performance
Показать описание
We are going to be diving into Data Architecture, and a key element is having queries that can execute with good performance. To achieve this in Salesforce, especially as the data volumes grow, you need to understand some key elements such as:
Query Optimizer
Selective Queries
Indexes
Query Plan Tool
One of the first places to start is to enable the Query Plan Tool and start to view the information it provides. In this video, I introduce the Query Plan Tool and how to enable it. I then run a few different Queries, showing the values returned.
This video is in the Salesforce Data Architect Set.
#salesforce #architect #data #queryplan
Connect with SteveTechArc
STA 2.3
Query Optimizer
Selective Queries
Indexes
Query Plan Tool
One of the first places to start is to enable the Query Plan Tool and start to view the information it provides. In this video, I introduce the Query Plan Tool and how to enable it. I then run a few different Queries, showing the values returned.
This video is in the Salesforce Data Architect Set.
#salesforce #architect #data #queryplan
Connect with SteveTechArc
STA 2.3
0:08:59
Data Architecture: Using the Query Plan Tool to Understand Query Performance
0:10:33
BigQuery Architecture
0:02:54
Data Modeling vs. Data Architecture
0:28:10
Data Architecture 101 for Your Business
0:03:43
Data Architecture Explained in under 4 minutes.
0:08:20
Build a Big Data Analytics Pipeline Using Modern Data Architecture | Amazon Web Services
0:12:09
Integrating Serverless Data Lake with Modern Data Architecture
0:11:06
Build Modern Data Architecture Using Native AWS Services | Amazon Web Services
0:00:57
What is Sharding? #sql #nosql #aws #jpa #mysql #db2 #postgresql #sqlserver #database
0:11:11
What is a Headless Data Architecture?
0:05:22
Database vs Data Warehouse vs Data Lake | What is the Difference?
0:56:40
Our DataMesh Journey: data architectures for microservices by Carlos Saona-Vázquez - Spring I/O 2022...
0:44:56
Crash Course in Data Architecture
0:05:16
Let's Compare the Kimball and Inmon Data Warehouse Architectures
0:06:34
Streaming Analytics on AWS Modern Data Architecture | Amazon Web Services
0:52:27
Big Data Architecture Patterns: The Tableau Perspective
0:53:01
Knowledge Graphs as a Data Platform - Data Architecture Summit 2017
0:22:34
Evolution of Data Architectures and How to Build a Lakehouse
0:56:07
The Value of the Modern Data Architecture with Apache Hadoop and Teradata
0:56:14
AWS Summit SF 2022 - Understanding and achieving a modern data architecture (ANA201)
0:21:34
Materialized Column: An Efficient Way to Optimize Queries on Nested Columns
0:24:49
Modern Data Architecture in Minutes
0:23:37
Simplify your data architecture for data-intensive applications
0:59:26
Creating a Data Architecture for Maximum Efficiency and Productivity
Комментарии