SQL Query Optimization - Tips for More Efficient Queries
Вставка
- Опубліковано 5 жов 2022
- 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.
Thanks Cody! Love the simplicity
thanks,I watched all videos about SQL reaaaaaaallly helpful 😍
Wisdom knowledge to the point of info. I owe you for the same.
Underrated channel
Novice SQL user, thanks for this!
Thanks man, valuable content.
In ORACLE I use Fetch at the end of a query instead of Top or Limit
Nice
Hi Cody, Do you offer a class on SQL and data analitics
Thanks alot. how can we remove duplicated then?
bang nanya kenapa ya, ukuran size mysql cpanel sy sangat besar, padahal ukuran asli size phpmyadmin nya sangat kecil ?
Thank u Master
wtf does selecting more columns do if you want the unique name and age pairs?
He forgot to say use group by instead
I thought I might see something like use a CTE...
What are wildcards?
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