SQL Query Optimization - Tips for More Efficient Queries

In SQL, query optimization involves making our queries more efficient. We do so to improve performance, reduce response time, conserve technology resources, and save money.

[@badooral-holibi2281]

thanks,I watched all videos about SQL reaaaaaaallly helpful 😍

[@soundarapandian8374]

Wisdom knowledge to the point of info. I owe you for the same.

[@galarnan4078]

Thanks Cody! Love the simplicity

[@VAIBHAVMALHOTRA19]

Underrated channel

[@PlasmaCoolantLeak]

Novice SQL user, thanks for this!

[@timm8220]

In ORACLE I use Fetch at the end of a query instead of Top or Limit

[@Cahangir]

Thanks man, valuable content.

[@salomengoh1]

Hi Cody, Do you offer a class on SQL and data analitics

[@maryam4071]

Thanks alot. how can we remove duplicated then?

[@yuvrajb4696]

Nice

[@aaaccciiiddd]

wtf does selecting more columns do if you want the unique name and age pairs?

[@RiyazParve]

He forgot to say use group by instead

[@rahmatjo6837]

bang nanya kenapa ya, ukuran size mysql cpanel sy sangat besar, padahal ukuran asli size phpmyadmin nya sangat kecil ?

[@jamesbond-fk3eq]

Thank u Master

[@psz34]

What are wildcards?

[@Xevailo]

Wildcards are "placeholders" for when you want to leave some aspects of a filter open for variation. Say you have a tabel of books, and you want to SELECT all the books that start with "The": since you can hardly know all book titles with "The " at the beginning by heart and there could be also more new books being released in the future that start with "The ", you cannot (reasonably) do a "WHERE title = 'The giver' OR title = 'The holy bible' OR ... ". This is where Wildcards come into play: by saying "WHERE title = 'The %' " you fetch all the books that have a title that starts with "The ", without having to know every single one of them. And if you put this wildcard (the % in your query) at the beginning or a string, say "WHERE lastname = '%son' ", you SELECT all records that end in "son", like "Eriksson", "Stevenson" etc

[@John5ive]

I thought I might see something like use a CTE...