Загрузка видео...

Не удалось загрузить видео

На главную

Can adding an index bring down the cost of that SQL query from $0.00000208 to $0.00000018? And how would you know? Aurora DSQL's new EXPLAIN ANALYZE VERBOSE feature tells you exactly how much a SQL query costs to run, so you can see exactly how tuning efforts affect your cost.

MarcJBrooker's profile picture

Marc Brooker

25,627 subscribers

47,031 просмотров • 8 месяцев назад •via X (Twitter)

LIVE

Anya Rossi• Live Now

Private livecam show

Комментарии: 0

Нет доступных комментариев

Здесь появятся комментарии из оригинального поста

Похожие видео

🆕 Introducing PrismaGPT, a query helper built on GPT-4 🎉 * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query 👍
0:43

🆕 Introducing PrismaGPT, a query helper built on GPT-4 🎉 * Drop in your Prisma schema * Ask for what you want * Get back a Prisma Client query and raw SQL Great for when you know what you need but aren't quite sure how to construct the query 👍

Ryan Chenkie

94,195 просмотров • 3 лет назад

How much does it cost to open a DLMM position? Heavymetalcook breaks down the costs involved to create a position — position rent (refundable) and bin array creation rent (non-refundable) — as well as how you can view the full cost details on the position creation UI.
1:33

How much does it cost to open a DLMM position? Heavymetalcook breaks down the costs involved to create a position — position rent (refundable) and bin array creation rent (non-refundable) — as well as how you can view the full cost details on the position creation UI.

Meteora

16,174 просмотров • 1 год назад

Just made a calculator that will tell you exactly how much money you're leaving on the table with your current sales process It's SHOCKING how many agency owners don't use math to make decisions It also breaks down: - Each step of the sales process so you know which would be the highest leverage to improve - Exactly how many leads, calls, and closes you need in order to hit your target revenue Like + comment "math" and send it to you (Must be following so I can dm you otherwise I can't)
8:19

Just made a calculator that will tell you exactly how much money you're leaving on the table with your current sales process It's SHOCKING how many agency owners don't use math to make decisions It also breaks down: - Each step of the sales process so you know which would be the highest leverage to improve - Exactly how many leads, calls, and closes you need in order to hit your target revenue Like + comment "math" and send it to you (Must be following so I can dm you otherwise I can't)

Clinton

20,147 просмотров • 9 месяцев назад

How peak experiences slowly leave you feeling disappointed… According to Andrew Huberman, these moments come at a cost. Here’s how they affect you and what you can do to fix it:
0:27

How peak experiences slowly leave you feeling disappointed… According to Andrew Huberman, these moments come at a cost. Here’s how they affect you and what you can do to fix it:

Mathew Bowyer

23,706 просмотров • 1 год назад

SEO Tip: Ahrefs new "Content Changes" feature will show you the EXACT changes a competitor used to improve organic traffic. Here's how you use it: This is one of the biggest feature adds to any SEO tool that I can remember. Ahrefs new "Content Changes" will automatically detect when substantial changes were made to a page. Then you can see the exactly changes that were made to the content so you can leverage those insights for your own page. Here's how you do it:
2:50

SEO Tip: Ahrefs new "Content Changes" feature will show you the EXACT changes a competitor used to improve organic traffic. Here's how you use it: This is one of the biggest feature adds to any SEO tool that I can remember. Ahrefs new "Content Changes" will automatically detect when substantial changes were made to a page. Then you can see the exactly changes that were made to the content so you can leverage those insights for your own page. Here's how you do it:

Chris Long

21,675 просмотров • 2 лет назад

Here’s my question for Republicans in Congress: How can you explain to Americans that you voted to double or triple the cost of their health insurance?
1:28

Here’s my question for Republicans in Congress: How can you explain to Americans that you voted to double or triple the cost of their health insurance?

Elizabeth Warren

119,092 просмотров • 6 месяцев назад

when you dont know how to read a flowchart but have to explain the cost of school meal
2:19

when you dont know how to read a flowchart but have to explain the cost of school meal

Joel Picard

4,107,598 просмотров • 1 год назад

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.
1:01

Quick demo of Zero’s new background queries. Zero’s sync is query-based. Rather than specifying what data you want using rules or some other separate system, you just use queries. Right inside the client app, you do a query using a full sql-style language. You get filters, subqueries , limits, etc. Zero syncs the data backing these queries to the client. It’s important to realize Zero isn’t really a cache. It’s a replica. It’s eagerly replicating a precise snapshot of a slice of your database - the slice covered by the queries you have open. So there is never stale data in Zero. When you close a query we delete the rows uniquely returned by that query because we can no longer keep them up to date. Of course that kind of sucks for the common case of doing a query, navigating, then pressing “back”. Ideally we want that back nav to be fast. To address this Zero 0.17 adds background queries. You can add a ttl to a query and it will keep running and syncing in the background. This is much different than normal caching because this data stays up to date. If you make the same query again, the results will be *instantly* available *and already up to date with server*. If you make a different query the data from the background query is used client-side to answer the new query instantly if possible. This all happens completely automatically. Just by adding the ttl flag.

Aaron Boodman

18,808 просмотров • 1 год назад

Introducing my SQL Agent: How to automate SQL with AI. Today I'll share how to make a SQL AI Agent that can automatically connect to databases, understand the tables and schema, and write and execute high-quality SQL queries. I'll guide you through setting up the SQL Agent, creating dozens of SQL queries, and returning the data from those queries. This AI is a huge help!! Table of Contents: 00:00 Introduction 01:30 How to Get The AI Data Science Agents 03:23 AI Tips Newsletter: Get The Code 04:00 Project Setup 06:30 Setting Up Your First SQL Agent 11:00 Running SQL Queries with the SQL Agent 14:25 Next Steps, Project Roadmap, & AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code by Joining my Python AI/ML Tips Newsletter: P.S. - Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, February 12th, I'm sharing one of my best AI Projects: SQL-Writing Business Intelligence Team Register here (570+ registered):
17:04

Introducing my SQL Agent: How to automate SQL with AI. Today I'll share how to make a SQL AI Agent that can automatically connect to databases, understand the tables and schema, and write and execute high-quality SQL queries. I'll guide you through setting up the SQL Agent, creating dozens of SQL queries, and returning the data from those queries. This AI is a huge help!! Table of Contents: 00:00 Introduction 01:30 How to Get The AI Data Science Agents 03:23 AI Tips Newsletter: Get The Code 04:00 Project Setup 06:30 Setting Up Your First SQL Agent 11:00 Running SQL Queries with the SQL Agent 14:25 Next Steps, Project Roadmap, & AI Bootcamp Github to AI Data Science Team (Army of Copilots): Get the Code by Joining my Python AI/ML Tips Newsletter: P.S. - Want to learn how to build AI projects companies actually want? (live Python Code) On Wednesday, February 12th, I'm sharing one of my best AI Projects: SQL-Writing Business Intelligence Team Register here (570+ registered):

Matt Dancho (Business Science)

77,293 просмотров • 1 год назад

If you spent your whole life afraid to go past your limits. You'll never know where your limit is. You'll never know exactly how much you can actually do.
0:28

If you spent your whole life afraid to go past your limits. You'll never know where your limit is. You'll never know exactly how much you can actually do.

Andrew Tate

169,961 просмотров • 8 месяцев назад

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.
2:37

This Python script helps you better understand how embeddings work for SEO. Input a sentence + a query and BERT will calculate a content "Similarity Score": Search engines use embedding models to translate your content into numeric values. This is how they're able to mathematically determine whether a page on your site is actually relevant to a query someone is searching for. Once both the content and query are run through embeddings - they can calculate the "cosine similarity" or how similar the two entities are to each one. With this Python script, you can actually visualize how cosine similarity works for yourself. To you use you'll simply: 1. Save the Python script to a text file 2. Use your Terminal to run the script 3. You'll be prompted for both a "Sentence" and "Query" 4. Once entered, the script will calculate a "Similarity Score" between the text and query. This is how relevant your sentence is for the target keyword. By running this, you'll see that search engines are able to come with an calculation of content relevance. You'll need to think about the content on your site the same way - which sections have high scores and which ones have low ones? I've linked the Python script in the comments below. No coding knowledge is required and it walks you step by step on how to implement it.

Chris Long

13,185 просмотров • 2 лет назад

Q: How are you going to bring down the cost of food and groceries? Trump: We allow a lot of farm product into our country. We're not going to allow so much to come in
1:14

Q: How are you going to bring down the cost of food and groceries? Trump: We allow a lot of farm product into our country. We're not going to allow so much to come in

Headquarters

2,206,307 просмотров • 1 год назад

Have you ever handed over your phone to a stranger in need of “just one call”? This simple act of kindness could cost you your entire savings. From intercepting your OTPs to draining your bank accounts, scammers can cause serious damage without you even realizing it. In this video, we explain how these scammers operate, who they target, and most importantly, how you can protect yourself.
4:20

Have you ever handed over your phone to a stranger in need of “just one call”? This simple act of kindness could cost you your entire savings. From intercepting your OTPs to draining your bank accounts, scammers can cause serious damage without you even realizing it. In this video, we explain how these scammers operate, who they target, and most importantly, how you can protect yourself.

Zerodha

28,478 просмотров • 1 год назад

Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.
0:22

Google open-sourced MCP Toolbox for Databases. I gave it access to everything else. For context, Google's MCP Toolbox for Databases is an open-source server that lets AI agents securely query structured databases like PostgreSQL and MySQL through the MCP protocol However, most enterprise knowledge doesn't actually live in databases. It's scattered across emails, Slack threads, GitHub repos, Salesforce records, customer reviews, and internal docs. So Agents can't see any of it, which means they're working with a fraction of the context they need. I fixed that using MindsDB. It acts as a universal SQL layer that sits on top of all your data sources: structured, semi-structured, and unstructured. This means you can query Salesforce, Gmail, GitHub, S3 files, Jira, and 200+ more sources using SQL syntax. The clever part is how it connects to the MCP Toolbox. MindsDB exposes everything through MySQL, so from the Agent's perspective, it's just running SQL and getting context back. It doesn't know or care that the data came from five different sources behind the scenes. This setup unlocks some powerful capabilities: → One SQL interface for dozens of enterprise sources → Cross-datasource joins (combine GitHub and CRM data in a single query) → Built-in ML capabilities for working with unstructured data → Simple MCP tools that now have massively expanded reach In the video below, the Agent queries GitHub data and a customer review database in one SQL query. So what used to require ETL pipelines and weeks of engineering effort now happens instantly. At the end of the day, AI agents are only as useful as the data they can access. This gives them a lot more to work with. I have shared the GitHub repo in the replies, where you can find more details about this.

Akshay 🚀

39,331 просмотров • 5 месяцев назад

THE MEDICARE TRAP AMERICANS DON'T SEE COMING Most Americans turning 65 have no idea how complicated Medicare actually is — and one wrong move can cost you for life. I sat down with Ari Parker — Stanford Law grad, Medicare expert, and co-founder of Chapter — to map out exactly what you need to know before it's too late.
9:10

THE MEDICARE TRAP AMERICANS DON'T SEE COMING Most Americans turning 65 have no idea how complicated Medicare actually is — and one wrong move can cost you for life. I sat down with Ari Parker — Stanford Law grad, Medicare expert, and co-founder of Chapter — to map out exactly what you need to know before it's too late.

Dinesh D'Souza

57,437 просмотров • 2 месяцев назад

NOW: Secretary Hegseth snaps back at Dem. Rep. Ro Khanna for "gotcha" questions on how much the war in Iran is costing Americans: KHANNA: "You don't know how much it cost the taxpayer?" HEGSETH: "I would simply ask you what the cost is of an Iranian nuclear bomb." "What would you pay to ensure Iran doesn't get a nuclear bomb?"
0:44

NOW: Secretary Hegseth snaps back at Dem. Rep. Ro Khanna for "gotcha" questions on how much the war in Iran is costing Americans: KHANNA: "You don't know how much it cost the taxpayer?" HEGSETH: "I would simply ask you what the cost is of an Iranian nuclear bomb." "What would you pay to ensure Iran doesn't get a nuclear bomb?"

Fox News

1,074,858 просмотров • 3 месяцев назад

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?
1:25

SQL has levels to it: - level 1 SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT Master these basic keywords and you’ll be well on your way to mastering SQL. - level 2 Mastering JOINs: Most common JOINs: INNER and LEFT Less common JOINs: FULL OUTER Joins you should avoid almost always: RIGHT and CROSS JOIN Mastering common table expressions (CTEs). The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later. Using variables like this you can master algorithm techniques like recursion, breadth first search and more! CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries. - level 3 Mastering window functions Window functions have 3 pieces: The function (i.e. SUM, RANK, AVG) The over clause to start the window The window definition which has 3 pieces: - how to split the window up with PARTITION BY - how to order the window with ORDER BY - how to restrict the window size with ROWS clause (useful for rolling monthly averages) Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times. - level 4 You understand table scans, b-tree indexes, and partitioning schemes to increase performance. Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post. B-trees indexes allow for efficient scanning of data in the WHERE clause. Use explain plans to understand if an index is actually being used or not! Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question. What else did I miss for mastering SQL?

Zach Wilson

79,625 просмотров • 1 год назад