SQL | Which SQL Query has a better performance? | #sqlinterviewquestions #sql #sqlforbeginners

preview_player
Показать описание
In this SQL Quiz, there are two SQL Queries. Which one has a better performance?
#sqlinterviewquestions

Must Do Data Analytics Certifications -

Google Data Analytics Professional Certificate

Google Advanced Data Analytics Professional Certificate

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
  1. Learn at Knowstar
  2. sql performance tuning
  3. sql index
  4. sql quiz
  5. sql interview questions
Рекомендации по теме
How to Install 0:08:10

How to Install Microsoft SQL Server & SSMS on Windows 10/11 [ 2023 Update ] Complete guide

Learn Basic SQL 0:17:40

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

SQL Explained in 0:02:23

SQL Explained in 100 Seconds

SQL Query to 0:00:23

SQL Query to Calculate The Difference Between Two Dates? SQL Interview Questions And Answers #SQL

How To Download 0:05:49

How To Download and Install Microsoft SQL Server 2025

Basic SQL Commands 0:00:06

Basic SQL Commands #sql #sqlserver #basic #sqlbasics

Simple SQL code 0:00:17

Simple SQL code || Structured Query Language || SQL || RDBMS #programming

Cloud SQL for 0:04:01

Cloud SQL for SQL Server

Connect to Oracle 0:04:46

Connect to Oracle Database with Python

Find Highest , 0:00:59

Find Highest , lowest max min salary of each department SQL Server

SQL VIEWS | 0:05:20

SQL VIEWS | CREATE VIEW and DROP VIEW Statements | SQL Server Tutorial for Beginners

Dynamic SQL in 0:12:12

Dynamic SQL in SQL Server

MySQL vs Postgresql 0:16:05

MySQL vs Postgresql vs Microsoft SQL Server Management Tools | Which Option is Best?

How to Create 0:02:48

How to Create a Table | SQL Tutorial for Beginners | 2021

5 Basic SELECT 0:06:43

5 Basic SELECT Statement Queries in SQL

Nested Queries | 0:10:23

Nested Queries | SQL | Tutorial 18

SQL SELECT DISTINCT 0:01:46

SQL SELECT DISTINCT statement (return different values) | SQL Tutorial for Beginners | 2021

How to Run 0:03:51

How to Run SQL Online (without installing)

Raw SQL, SQL 0:16:19

Raw SQL, SQL Query Builder, or ORM?

Kysely first impressions 0:24:16

Kysely first impressions - Typescript SQL query builder and migrations

SQL Tutorial for 0:44:57

SQL Tutorial for Beginners

Secret To Optimizing 0:05:57

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

5 Best SQL 0:00:33

5 Best SQL Websites to Practice n Learn Interview Questions for FREE

SQL indexing best 0:04:08

SQL indexing best practices | How to make your database FASTER!

Комментарии
Автор

The 2nd query will be a better performer in this case.

Query 1 uses a concatenation to combine the two columns, and then it compares the result to the string 'Evelyn Brooks'. This involves additional string manipulation, and it's not very efficient, especially if the table contains a large number of records.
The 2nd query however, directly compares the columns to the respective strings 'Evelyn' and 'Brooks'. This is a more efficient comparison because it doesn't involve any extra string operations.

talzl
Автор

2nd as 1st one uses 2 columns and creates a dummy column for all records then tries matching with the string, however in the 2nd method where condition, it checks for first name and last name simultaneously and filters the records..
Please correct me if I am wrong

kayk
welcome to shbcf.ru