Why this query is fast

The Backend Engineering Show with Hussein Nasser

Hussein Nasser에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Hussein Nasser 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

2y ago 17:50

MP3•에피소드 홈

Welcome to another database question. In this question I created a community poll question and provided some answers. All answers can be correct of course but the question is what is the most efficient? this is what I try to explore in this video and compare how different database platforms such as mysql or Postgres differ in those implementations;

Table T with three integer fields A, B and C.

A has a primary key clustered index.

B has a secondary index.

Which query is more likely to be the most efficient?

0:00 Intro

1:00 The Question

3:20 WHERE C BETWEEN 50,50000

5:30 WHERE B BETWEEN 50,50000

13:20 WHERE C BETWEEN 50,50000

Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon)

https://network.husseinnasser.com

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)

https://database.husseinnasser.com

513 에피소드