๐จJUST IN: US STATE DEPARTMENT DIRECTOR QUITS DUE TO CONCERNING U.S MILITARY SUPPORT TO ISRAEL
Josh Paul, formerly the Director of Political-Military Affairs for the State Department, departed from his position.
He states his decision was driven by a profound dispute concerning the "lethal assistance to Israel."
Paul expressed his apprehension that the US was on the verge of repeating longstanding errors in its policy.
"I fear we are repeating the same mistakes we have made these past decades, and I decline to be a part of it any longer."
It's important to note that the United States currently allocates over $3.8 billion in military aid to Israel annually.
Source: International Institute for Strategic Studies
๐ง๐ผ๐ฝ ๐ฎ๐ฌ ๐ฆ๐ค๐ ๐พ๐๐ฒ๐ฟ๐ ๐ผ๐ฝ๐๐ถ๐บ๐ถ๐๐ฎ๐๐ถ๐ผ๐ป ๐๐ฒ๐ฐ๐ต๐ป๐ถ๐พ๐๐ฒ๐
Here is the list of the top 20 SQL query optimization techniques I found noteworthy:
1. Create an index on huge tables (>1.000.000) rows
2. Use EXIST() instead of COUNT() to find an element in the table
3. SELECT fields instead of using SELECT *
4. Avoid Subqueries in WHERE Clause
5. Avoid SELECT DISTINCT where possible
6. Use WHERE Clause instead of HAVING
7. Create joins with INNER JOIN (not WHERE)
8. Use LIMIT to sample query results
9. Use UNION ALL instead of UNION wherever possible
10. Use UNION where instead of WHERE ... or ... query.
11. Run your query during off-peak hours
12. Avoid using OR in join queries
14. Choose GROUP BY over window functions
15. Use derived and temporary tables
16. Drop the index before loading bulk data
16. Use materialized views instead of views
17. Avoid != or <> (not equal) operator
18. Minimize the number of subqueries
19. Use INNER join as little as possible when you can get the same output using LEFT/RIGHT join.
20. For retrieving the same dataset, frequently try to use temporary sources.
Do you know what is ๐ค๐๐ฒ๐ฟ๐ ๐ข๐ฝ๐๐ถ๐บ๐ถ๐๐ฒ๐ฟ? Its primary function is to determine ๐๐ต๐ฒ ๐บ๐ผ๐๐ ๐ฒ๐ณ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐ ๐๐ฎ๐ to execute a given SQL query by finding the best execution plan. The query optimizer works by taking the SQL query as input and analyzing it to determine how best to execute it. The first step is to parse the SQL query and create a syntax tree. The optimizer then analyzes the syntax tree to determine how to run the query.
Next, the optimizer generates ๐ฎ๐น๐๐ฒ๐ฟ๐ป๐ฎ๐๐ถ๐๐ฒ ๐ฒ๐ ๐ฒ๐ฐ๐๐๐ถ๐ผ๐ป ๐ฝ๐น๐ฎ๐ป๐, which are different ways of executing the same query. Each execution plan specifies the order in which the tables should be accessed, the join methods, and any filtering or sorting operations. The optimizer then assigns a ๐ฐ๐ผ๐๐ to each execution plan based on the number of disk reads and the CPU time required to execute the query.
Finally, the optimizer ๐ฐ๐ต๐ผ๐ผ๐๐ฒ๐ ๐๐ต๐ฒ ๐ฒ๐ ๐ฒ๐ฐ๐๐๐ถ๐ผ๐ป ๐ฝ๐น๐ฎ๐ป with the lowest cost as the optimal execution plan for the query. This plan is then used to execute the query.
Check in the image the ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ ๐ถ๐ป ๐๐ต๐ถ๐ฐ๐ต ๐ฆ๐ค๐ ๐พ๐๐ฒ๐ฟ๐ถ๐ฒ๐ ๐ฟ๐๐ป.
#technology #softwareengineering #programming #techworldwithmilan #sql
Is that demo too creepy?
Ignore that one lady sitting in the zona since the beginning is undetected. I am still trying to figure out why...
But zone timers work!
GitHub repository: https://t.co/xXMRaS3Guk
Why Can a Unique Index Store the Same Value Twice?
If your unique index includes nullable columns, its behavior to enforce uniqueness may not be what you expect it to do.
๐ Learn More
AI writing on steroids
This is a force-directed knowledge graph interface for GPT4 made by @hturan
It prompts new questions to ask based on its own generated responses.
๐จ / ๐ซ๐ท FRANCE RIOTS: PROPAGANDA/MISINFO WARFARE
Since the riots in France began, A TON of Misinformation has been spread on various social media platforms.
In this thread, Iโll address some videos/pictures that many believe are from the riots, when in fact, are not.
What drives me nuts the most are people who KNOW what they're posting is false, but they keep it anyway for engagement.
What is the best solution to misinformation & disinfromation?
Let's check out a few examples: /1